Auditing Transaction History

All Oracle Data Relationship Management operations are logged in the Transaction History. Each operation is recorded with a time stamp, the user name, the type of action performed, and other relevant information.

To query and view transaction history:

1. From the Home page, select Audit.
2. From Audit Type select Transactions.
3. On the Source tab, do the following:

   • From Version, Hierarchies, Nodes, and Request ID select the source for the audit.

   • Select the type of transactions to return: System Transactions, Data Transaction, or both.

4. On the Filters tab, select from these options:

   • Levels — Click to specify levels to filter:

     • Core –– Includes actions that indicate a change to version data (not metadata objects).

     • Logged –– Includes actions that indicate system activity occurred but did not result in additions, changes, or updates to data.

     • Loss –– Includes transaction history records that store data that has been lost due to a core action, such as deleting a node.

     • Result –– Includes actions that are associated with, and are a result of, a Core action.

     • Admin –– Includes actions that affect metadata objects (not version related data).

   • Actions — Click to specify transaction log action types to filter.

   • Properties — Click to specify a list of properties to filter.

   • Users — Click to specify users to filter.

   • Include Child Nodes — Select to include child nodes for nodes returned by the query.

   • Include Shared Nodes — Select to include shared nodes for nodes returned by the query.

   • From Date — Select and enter a start date.

   • To Date –– Select and enter an end date.

   • Filter to Current Session — Select to filter transactions to those performed during the current session.

   • From Transaction — Select and enter a start transaction ID.

   • To Transaction –– Select and enter an end transaction ID.

   • Max Records — Enter a value to limit the number of transactions displayed.

5. On the Columns tab, select the fields to be displayed as columns in the query results.
6. Click .

   The transaction history query results are displayed below the wizard.

7. After running the query, you can:

   • View the details of a transaction by clicking the arrow to the left of the row. The transaction details are displayed across Action, Object, History, and Request tabs.

     Note:

     The Request tab is available only if the transaction is associated with a workflow request.

   • Click Download, and then select the format for the file : TSV, CSV, PDF, RTF, or XLS.