Before You Begin
Purpose
This tutorial demonstrates how to create external commits in Oracle Data Relationship Governance.
Time to Complete
Approximately 20 minutes.
Background
External commits can be optionally configured on workflow tasks to immediately synchronize approved changes in a governance request to an external target system when the request is committed. For example, an external operation can run an SQL statement that inserts, updates, or deletes data, or it can invoke a SOAP or REST Web service to create, update, or delete data in an external system. When you use external commits in Oracle Data Relationship Governance, external data updates can be initiated after a Data Relationship Governance request is successfully committed. The external data source is accessed using external operations defined for database and Web service connections.
Scenario
In this tutorial, you learn how to configure workflow tasks, Add Product - External Commit and Update Planning - External Commit, with external commit operations. You review and use the Product Maintenance workflow model to create, enrich, and submit a change request to add a new product to Data Relationship Management, E-Business Suite General Ledger, and Planning and Budgeting Cloud Service.
What Do You Need?
Before starting this tutorial, you should have access to or have installed Oracle Data Relationship Management 11.1.2.4.330.
Configuring Workflow Tasks and a Workflow Model
In this section, you review workflow tasks that are configured with external commit oprations. You also review a workflow model that uses the reviewed workflow tasks.
-
Login as Admin to the Data Relationship Management Web Client.
-
On the Home page for the Administer task group, expand the Workflow Tasks node and double-click the Add Product – External Commit task.
-
On the Workflow Task page, select the External Commit tab. An external commit operation has been configured for the Add Product - External Commit task. Click the Edit icon (
) to view the parameters defined for the external commit operation. Note the value of the Commit Status Property. Close the Workflow Task page.
-
On the Administer page, double-click the Update Planning – External Commit task.
-
On the Workflow Task page, select the External Commit tab. An external commit operation has been configured for the Update Planning - External Commit task. Click the Edit icon (
) to view the parameters defined for the external commit operation. Note the value of the Commit Status Property. Close the Workflow Task page.
-
On the Home page for the Administer task group, expand the Workflow Models node and double-click the Product Maintenance – External Commit workflow model.
-
On the Workflow Model page, view the workflow stages and the workflow task for each stage. This model is configured to allow a new product to be added and enriched and then committed to Data Relationship Management, E-Business Suite General Ledger, and Planning and Budgeting Cloud Service.
Creating a Request with External Commits
-
Login as Operations to the Data Relationship Management Web Client.
-
On the Worklist page, select New Request and then Product Maintenance – External Commit.
-
On the Request page, click the Add Items button (
). In the Add Items dialog box, select the Add Product – External Commit task, define a name for the new product, and click OK to add the request item to the request.
-
Define a description for the new product. Click the ellipsis button (
) for the Parent property. Select the Browse tab and choose P_TP1 – Computers as the parent for the new product. Click OK.
-
Click the Submit button (
) to submit the new product request. Enter a title for the request and click OK. The request is validated and submitted to the next workflow stage.
Claiming the Request
-
Login as WFaulk to the Data Relationship Management Web Client.
-
On the Worklist page, view the submitted request for the new product. Double-click the request to open it.
-
Click the Claim button (
) to claim the request. Click the Add Items () button. From the Items tab, select the P_161 node and click the right arrow button to select it. Click OK.
-
A second request item is added to the request using the Update Planning – External Commit task. Planning properties for the new product can be defined on this request item. Click the Approve button (
) to approve the request and advance it to the next stage.
Committing the Request
-
Login as JStein to the Data Relationship Management Web Client.
-
Navigate to the Worklist page and open the new product request. Click the Claim button (
) to claim the request for the final commit stage. Click the Approve button () to commit the request.
-
View the request with a status of Committed. The new product has been committed to Data Relationship Management, E-Business Suite General Ledger, and Planning and Budgeting Cloud Service.
Verifying Commited Changes
-
Click the Activity tab. View activities for the external operations that were performed when the request was committed.
-
Close the workflow page tab. Click the Browse item from the navigation menu. Click the Find Nodes tab and search for node P_161. Click Go to find the node.
-
On the Hierarchy page, node P_161 is displayed and selected. From the Category dropdown, choose the Oracle General Ledger category. View the properties of the new product committed from the request. Note the Committed to GL property indicates the external commit was successful.
-
From the Category dropdown, choose the Planning category. View the properties of the new product committed from the request. Note the Committed to PBCS property indicates the external commit was successful.
-
Login to E-Business Suite as Operations. Navigate to the Segment Values screen and view the new product in the Operations Product value set which was added by the external commit operation for the request.
-
Login to Planning and Budgeting Cloud Service. Navigate to the Dimensions screen and view the new product in the Product dimension which was added by the external commit operation for the request.
