OIC - ERP - How to get the child process id from import request id using OTBI report

What: To show how to get child process id from process request id.

How: Highlevel:

• Create a BI report using SQL query 
• Call it from OIC using soap connection
• Check it from ERP schedule processes

Step1: create BI report

Sql query to use in data model:

See the below blogs:.

How to create data model and test sql:

oic-erp-how-to-test-sql-query-in-otbi

How to create BI reports:

oic-how-to-create-bi-report-in-oracle

 How to create eText based BI report:

oic-create-etext-template-based-bi

How to invoke erp Bi report:

oic-invoke-erp-bi-report

Step2:

Create a conneection using ExternalReportWSSServices wsdl

In the Integration, Invoke the connection and operarion as runreport and map as following:

• Provide name values pair as Name: P_REQUEST_ID & value: importRequestID
• provide report absolute path
• SizeofDatachunkDownload as -1

Step3: We can see the processes status from ERP Schedule process : 

Import accounting Trasactions is the import req id: 1720657

Child process : Create Accounting for Data Set : 1720660