Monday, March 7, 2022

OIC | How to call and read BI publisher report in OIC Integration

High level steps:

  1. Create a SOAP connection for the report service.
  2. Create a schedule integration and drag and drop the created soap connection and select operation as runReport.
  3. Map the required fields like reportAbsolutePath, NameValuesParameters etc.
  4. DecodeBase64 ERP response to readable format. 

Read the follow blog to know how to create BI publisher report in Cloud ERP:

Steps in detail:

Create a SOAP connection for the BI report call.

Here we will configure  " ExternalReprtWSSService 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.1
  3. WSDL URL Format : https://<your oracle cloud application instance domain>/xmlpserver/services/ExternalReportWSSService?WSDL
  4. 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.

Create a scheduled integration.

Drag and drop the created soap connection and probide endpoint name

Choose operation as runReport.

Keep it as default.

Edit the Map

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.)

In this case, I have used the following parameters:

ReportAbsolutePath: "/Custom/Integrations/Poc/InvoiceId_POC_REP.xdo"
sizeOfDadaChunkDownload: " -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.

Take an assign action and decode the base64 reaponse to reference using decodeBase64ToReference() function.

Now take a stage activity and use that referenced variable and read it using a sample csv file.

Add tracking , save, activate and submit run.

From Monitoring


  1. Hi Sanddy , It was really great article. I have a requirement to download the data not via running report but scheduling report. I am using /xmlpserver/services/ScheduleReportWSSService?wsdl to schedule it but how we can download the report data via using this service.

  2. Hi Ankur,
    Thanks buddy for your time. xmlpserver/services/v2/ScheduleService?wsdl or your mentioned service talso worked.
    1. call scheduleReport operation to call the BI with bursting to FTP, UCM , UCM delivery etc.
    2. call getScheduleReportStatus OPERATION to get the BI Run status.

    Today i did the same poc based on your question and will share it soon on blogs.


    1. HI Sanddy, Thanks for checking on this. I understand now. We need to use bursting to FTP the output file and from there we can download the file to OIC staging area.

    2. Yes Ankur, you can also check this blog, created today for your help:


Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...