Audit Trail

As you use Oracle Transportation Management to create and modify records, you may want to audit the database to determine whether specific records have changed. Most Oracle Transportation Management managers provide a View Audit Trail action/SmartLink on the Results page to view records that have changed based on Oracle Transportation Management events. For example, in Order Manager you can audit order changes based on whether orders are created or if specific data (e.g., dates, quantities, locations, status) for existing orders have been modified.

Note: You must have the audit property glog.audit.beforeafter set to on to be able to see changes to each database column.

You can access this action via:

• Classification > Trade Items > Actions > Audit Trail
• Customs > Declarations > Actions > Utilities > Audit Trail
• Customs > Declaration Lines > Actions > Utilities > Audit Trail
• Order Management > Purchase Order > Order Base > Actions > Audit Trail
• Order Management > Purchase Order > Order Base Line > Actions > Audit Trail
• Order Management > Purchase Order > Order Base Ship Unit > Actions
• Order Management > Order Release > Order Release > Actions > Audit Trail
• Order Management > Order Movement > Order Movement > Actions > Audit Trail
• Shipment Manager > Shipment Manager > Buy Shipments > Actions > Audit Trail
• Shipment Manager > Shipment Manager > Sell Shipments > Actions > Audit Trail
• Shipment Manager > Group Management > Shipment Group > Actions > Audit Trail
• Operational Planning > Schedule Management > Voyage > Actions > Audit Trail
• Shipment Manager > Location Management > Actions > Audit Trail
• Contract and Rate Management > Service Provider Manager > Audit Trail
• Contract and Rate Management > Contract Management > Rate Offering > Actions > Audit Trail
• Financials > Payment Invoice Management > Payment Invoice Voucher > Actions > Audit Trail
• Financials > Payment Invoice Management > Voucher > Actions > Audit Trail
• Financials > Billing Management > Billing > Actions > Audit Trail
• Financials > Damage Claim > Actions > Audit Trail
• Brokerage and Forwarding > Quote > Actions > Audit Trail
• Brokerage and Forwarding > Booking > BOL Book > Actions > Audit Trail
• Brokerage and Forwarding > Job Management > Job Details > Order Releases > Actions > Audit Trail
• Brokerage and Forwarding > Job Management > Job Details > Revenue > Actions > Audit Trail
• Brokerage and Forwarding > Job Management > Job Details > Non Freight Related Charges > Actions > Audit Trail
• Brokerage and Forwarding > Job Management > Job Details > Expenses > Actions > Audit Trail
• Fleet Management > Driver Management > Driver Manager > Audit Trail
• Fleet Management > Power Unit Management > Power Unit > Audit Trail
• Sourcing > Bid Creation > Project > Actions > Audit Trail
• Sourcing > Bid Creation > Bid > Actions > Audit Trail
• Transactions > Trade Transactions > Actions > View > Audit Trail
• Transactions > Trade Transaction Lines > Actions > View > Audit Trail
• Master Data > Trade Items > Actions > Audit Trail
• Master Data > Parties > Actions > View > Audit Trail
• Master Data > Power Data > Data Loading > Data Version > Actions > Audit Trail
• Master Data > Item Classifications > Actions > Audit Trail
• Licenses and Registrations > Registrations > Actions > Audit Trail
• Licenses and Registrations > Licenses > Actins Audit Trail
• Restricted Party Screening > Parties > Actions > View > Audit Trail

You can perform the following tasks with the Audit Trail manager:

• Run a business object audit based on all events or a specific business object event.
• View data changes including before and after value changes
• Control which business objects can be audited.

You can also use the Audit Trail Manager to audit changes. This manager lets you audit data from across Oracle Transportation Management managers that support auditing, or you can select the specific events from which to audit.

Note: Additionally, you can configure contacts to receive email notifications when specific events occur.

Configure Audit Trail

Before you can audit any records, you must add at least one contact (per domain) using the Communication Manager. The contact must be assigned the Audit (AUD) communication method. Then you can assign the contact to the specific Oracle Transportation Management events you want to audit.

By default, any user in that domain that is assigned to the DEFAULT level can perform an audit. The Oracle Transportation Management Administrator can restrict audit access using the Security Services options.

All audit records are stored in the domain where the contact that has auditing privileges resides. If your Oracle Transportation Management installation has multiple domains or subdomains, you can configure the audit contact to store audit records in a specific domain so that you can audit other domains.

Use the following steps as a guide.

Creating Audit Contact:

1. Navigate to Business Process Automation > Communication Manager > Contacts.
2. Create a new contact in the Communication Manager or modify an existing contact.
3. Enter the appropriate domain in the Recipient Domain Name field that determines where you want to store audit records. This allows users in that domain to perform an audit on the records from your current domain.
4. In the Com Method ID field select AUD.
5. Enter a Rank of 1.
6. Click Save.
7. Click Finished.

Assigning Contact to Contact Notifications:

Navigate to Business Process Automation > Communication Manager > Contact Notification.

1. You can use the Search page to find a specific contact notification or leave the page blank and click Search to display a list of all contact notifications.
2. Edit the contact notification and assign the contact.
3. Select AUD as the communication method and click Save.
4. Click Finished.
5. Repeat this procedure for each contact notification that you want to audit.

Setting Level of Audit Detail:

The following levels of auditing can be used to review how a business object has changed.

• Data Change Auditing saves information including the ID of what was changed, the change made, the user who made the change and lastly, the date and time of the change (default level).
• Before/After Value Auditing collects this and the before and after values as well as which tables changed and the table keys. If you want to use the detailed auditing, then you must first turn it on via a properties file setting. Once this level of auditing is turned on, a detailed audit for every event that is currently configured for audit is saved. You can restrict the detailed auditing to only those objects defined in Audit Control.

Audit Records

You can audit specific records from the Results pages of most managers:

1. To perform an audit from any of the Managers mentioned above, choose the Search option.
2. Complete the Search page or leave it blank, and click Search to display a list of records on the Results page.
3. Select one or more records to audit, and choose the View Audit Trail action from the drop-down list next to the Go button.
4. Click Go, and enter audit criteria (optional) that determines the type of audit you want to perform, the user who may have changed the data, and a time frame in which the data may have changed, etc.

Using the Audit Trail Manager:

You can also use the Audit Trail Manager under Business Process Automation to conduct a more global audit across all record types mentioned above. For example, you can audit orders, rates, shipments, invoices and bills from one page based on the contact notification events that are activated for auditing. You can also audit against specific record types and events as well by selecting audit criteria.

The Audit Trail Manager also provides menu links for searching by user or transactional event.