Scroll to top
Please assign a menu to the primary menu location

How to Call a BIP Report from OIC

Roshan - June 28, 2022 - 2 comments

Reading Time: 4 minutes


Many times we need to fetch SaaS in OIC for processing, one of the way is to call the BIP report and fetch the data into OIC.


To call the BIP report we need to use External Report WSS Service SOAP service. By using the run report operation we can call the report and report response will be base64 format, in OIC we need to write the response to stage directory using opaque schema and then read the stage file using the report output schema.


Let’s take a example of calling SaaS BIP report and calling local integration.


  1. Oracle Fusion Instance with BIP report
  2. Oracle Cloud Instance
  3. SOAP connection to call BIP report (WSDL: https://servername/xmlpserver/services/ExternalReportWSSService?WSDL)
  4. Local integration which accepts the payload
  5. Opaque file (

Let’s get started.

Step 1: First let’s validate the report in SaaS, Login in to the SaaS instance and navigate to Tools -> Reports and Analytics and click on Browse catalog as shown in the below screenshots

BIP Report in OIC


BIP Report in OIC

Step 2: Navigate to the report path and click on edit and click on view a list let’s see the report output format (Ex: in our case it is text) and run the report to save the output which will be useful in next steps as shown below in the screenshots. Note report output should be in OIC readable format like XML, CSV, JSON etc.

calling BIP Report in OIC

Run the report

run the bip report

Save report output: Click on settings button and click on export to save the output file.

Also copy the report path which is required to pass in web service payload

save bip report

Step 3:  Now let’s navigate to OIC and create a integration to call the report and then call the local integration with report data as shown below in the screenshot.


Step 4: Create a new integration with schedule orchestration and then select the SOAP connection created to call BIP report as shown below in the screenshots. Select the runReport operation to call the BIP report as shown below in the screenshot.

run bip report


reportAbsolutePath  : Report path from BIP

sizeOfDataChunkDownload : we need to provide “-1” so that entire data from BIP will be fetched. If any other value provided only partial / no data will be fetched.


Step 5: Now we need to write the base64 response of BIP report to a opaque schema file of stage write. Select the stage write activity and provide necessary details as shown below in the screenshots.

base64 response


Mapper: we need to pass reportBytes to the opaqueElement in map activity as shown below.

mapper in BIP report

Step 6: Now let’s read the stage file using the report output schema, select stage read activity and provide necessary details as shown below in the screenshots.




Step 7: Now let’s call the local integration with the report data, select the integration activity and configure as shown below


Mapper: Now let’s map the report read response to local integration as shown below.



Using this approach we can call the BIP report and process the data in OIC as required.

Author avatar


Roshan comes with an extensive experience in the Oracle Implementation domain after completing his Electronics and Communication Engineering from Bengaluru. He holds a plethora of professional certifications from Oracle after starting as an Associate Developer role and quickly made his way to a Senior Manager. He has worked with clients across the globe in ANZ, EMEA, APAC and Europe. At Conneqtion Group, Roshan has been a key part of managing the organization’s largest risk teams apart from sharing his experience and skills to develop and nurture young talent with his dynamic vision.   

Related posts


  1. basavaraj

    After decoding the report bytes we can call directly read file no need of write stage file activity.
    and what if bip reort exceeds 10 mb?

    • Karan Tulsani

      We will utilise same approach now till 50 MB as Oracle has recently increased the limit. If data is more than 50MB then it is suggested to use BIP Bursting in UCM or SFTP and get the data.

Post a Comment

Your email address will not be published. Required fields are marked *