OIC - Invoke ERP BI report | Create ExternalReportWSSService wsdl connection in oracle integration

Usecase: Here, we will see the steps to invoke a BI Report in an Integration

• Create ERP SOAP Connection
• Create an integration and configure BI report Invoke
• Mapping the required fields
• Decode the BI base64 response

Create Connection : 

Here we will configure  " ExternalReportWSSService WSDL URL " which can be used to run a report. The same connection we will use in below steps while developing integration.

1. Navigate to connection window and select SOAP adapter, give any meaningful name for connection.
2. Enter the ExternalReportWSSService WSDL URL  and Select the TLS Version. TLS Version depends on your ERP Cloud Application Instance. Mostly it is TLSv1.1WSDL URL Format : https://<your oracle cloud application instance domain>/xmlpserver/services/ExternalReportWSSService?WSDL
3. Choose Security policy as Username Password token and Enter the *Username and *Password of the Oracle Cloud Application Instance. Click SAVE and TEST the Connection.

Steps with screenshots:

Create Integration :

Create one Scheduled Integration by giving some meaningful name >>  Search for the connection which we have created above and select it. Enter some meaningfull name(ex: invoke BI Report) and then click NEXT. >>  Select the operation = runReport and then click NEXT >> In headers configuration window, select Accept attachments in response. Click Next

SOAP Endpoint configuration completed. Click Done.

Mapping the required fields:

Now let's do the MAPPINGS. We will pass all the required fields to invoke BI report ( like absolute Report Path, size of data chunk download, Report Parameters Name and its Value ,attribute template etc.)

For my case I have used the following:

reportAbsolutePath* element =Custom\Integrations\Inbound\POC\eTEXT_INV_ID_SEQ.xdo

sizeOfDataChunkDownload*="-1"

You can also use the following paramters as per your requirement:

Expand the "parameterNameValues" element

Expand "Item" and then enter your BI Report Parameter name in name* element 

Now expand values* and map or pass Parameter Values in Item element .

Parameter names and its values configuration completed

*Note : suppose you have multiple parameters for your BI Report then you have to repeat the Item tag and then pass the Parameter name and its Values.

Decode Base64 BI report response:

Use decodeBase64(reportBytes) and store in a variable and then it can contain carriage return so we need to use a custom javascript and remove the carriage returns to get the actual data.

Use my post to know how to remove carriage returns using JS - oic-javascript-to-remove-carriage-return

Inside this step we will enable the tracking and do one round of testing - Enable the Tracking - BI Report call configuration completed. Click save and Close the integration edit window - Activate the integration - Submit the integration by clicking Submit now and then click on Instance Id to track the flow - Once processing succeeded , open the flow by clicking start time - Click on active stream and check the payload received as output from report