Before You Begin
This tutorial demonstrates how to audit transactions originating from committed governance requests in Oracle Data Relationship Management.
Time to Complete
Approximately 10 min.
Governance requests which are committed to a Data Relationship Management version result in transactions recorded in the transaction history for auditing purposes. The transaction history can be queried to identify the changes made by a committed request, who was responsible, and when they occurred. Transactions are linked to requests so users can follow the audit trail from a transaction back to the governance request from which it originated.
In this tutorial, you query transaction history to identify changes made to a hierarchy which originated from a committed governance request. You can view request details for each transaction and navigate to the originating request for complete information about why the change occurred.
What Do You Need?
Before starting this tutorial, you should:
- Have access to or have installed Oracle Data Relationship Management 18.104.22.168.311.
- Have access to or have installed the COAMGMT Data Relationship Management application. You can download the application here and use these instructions to install and configure the application.
- Have built workflow tasks and a workflow model by completing the Building A Workflow Model With Conditional Stages tutorial.
- Have created a change request and loaded request items by completing the Loading Request Items from a Source File tutorial.
- Have processed the change request by completing the Processing a Change Request With Conditional Stages tutorial.
Logging On to the COAMGMT Application
Launch Data Relationship Management Web Client.
The logon page for Oracle Data Relationship Management is displayed.
Log on to the COAMGMT application as user JStein with a password of Welcome!.
The Browse page is displayed.
Auditing Transactions for Governance Requests
Querying Transactions By the Request ID
In this section, you query transactions for a specific request by filtering on request ID.
Click Worklist and then click All.
The Worklist page displays governance requests. Copy a request ID that you would like to audit (for example, 18).
The Audit page is displayed. By default, the Audit Type is set to Transactions.
On the Source tab, in the Request ID text box paste the request ID (for example, 18) that you copied in step 1 and clear the System Transactions option.
On the Source tab, click the ellipsis button () for Hierarchies. In the Select Hierarchies dialog box, select Vision Jan 2013 from the Version drop-down list and Parent Total from the Hierarchy drop-down list, and click the Select button ().
Select the Filters tab and clear the Filter to Current Session option.
Select the Columns tab and select the Workflow Request ID column. Optionally, move the Workflow Request ID column to the top of the list of the selected columns.
Click the Run Query button ().
The query returns a list of transactions that are associated with the workflow request 18.
Identifying Transactions Originated From Requests
In this section, you query trasactions to identify those that have been originated from workflow requests.
On the Source tab, clear the Request ID text box.
The Request ID resets to 0 (zero).
Click the Run Query button ().
The query returns a list of transactions including those that are associated with the workflow requests that added nodes into the Parent Total hierarchy. The Workflow Request ID column values identify the originating request for each transaction returned.
Click the Expand icon () for the transaction that added the 6230 node.
The transaction details are displayed across Action, Object, History, and Request tabs.
Select the Request tab to view the request details for the transaction.
The Request tab displays information associated with the Add Node transation such as request id and title, workflow model upon which the request is based, the workflow task and stage title, the user name who submittied the request, and the timestamp of the request submission.
Optional. If you want to view all the request details, click the Navigate to Request button ().
Log out as user JStein.