Before You Begin
Purpose
This tutorial demonstrates how to audit transactions originating from committed governance requests in Oracle Data Relationship Management.
Time to Complete
Approximately 10 min.
Background
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.
Scenario
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 11.1.2.4.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.
View Image -
Log on to the COAMGMT application as user JStein with a password of Welcome!.
The Browse page is displayed.
View Image
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).
View Image -
Click Audit.
The Audit page is displayed. By default, the Audit Type is set to Transactions.
View Image -
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.
View Image -
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 (
).
View Image -
Click OK.
View Image -
Select the Filters tab and clear the Filter to Current Session option.
View Image -
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.
View Image -
Click the Run Query button (
).
The query returns a list of transactions that are associated with the workflow request 18.
View Image
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).
View Image -
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.
View Image -
Click the Expand icon (
) for the transaction that added the 6230 node.
The transaction details are displayed across Action, Object, History, and Request tabs.
View Image -
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.
View Image -
Optional. If you want to view all the request details, click the Navigate to Request button (
).
View Image -
Log out as user JStein.