How to call BIP Report from Oracle Integration Cloud (OIC)?

on



  • Create a BIP report. Click here to view the steps
  • Open the report and save the report in a sample.csv file





  • Open OIC Instance and go to Integrations -> Connections

  • Click on Create button on Top Right corner and select SOAP adapter

  • Enter the Name, select Role as Invoke and give it a description. Click on Create once done.
  • Enter the below details:
        WSDL URL: https://<hostname>.oraclecloud.com/xmlpserver/services/ExternalReportWSSService?WSDL

Security Policy: Basic Authentication and give Username & Password
  • Click on Test and then click Validate and Test




  • Click on Save button once done. You connection tested successfully and now is ready to be used in integrations.
  • Go to integrations and click on Create button to create new integration
  • Select the integration type as App Driven Orchestration

  • Give the integration name and click Create button



  • Add a new REST type trigger as starting point of your integration

  • Enter the name of your endpoint and click Next

  • Enter the resource relative URI, enable parameters for the endpoints and check the option to enable end point receive the response. Click Next button.



  • Add query parameters pVendorNum

  • Enter the JSON as inline:
{
  "VendorId" : "",
  "VendorName" : "",
  "VendorNumber" : ""
}


  • Click on Done


  • Add "EXTERNAL_REPORT_SERVICE_CONN" that we created earlier:


  • Enter the endpoint name


  • Select the operation "runReport"


  • Click Next button


  • Click Done button


  • Integration will look like below:

  • Edit the CallBIPReport Mapper and perform the below mapping:
  • SizeOfDataChunkDownload as "-1"


  • ReportAbsolutePath as "/Custom/Sample/TestReport.xdo"

  • Parameter Name as "p_vendor_number"

  • Add mapping for parameter values

  • Add mapping for attributeFormat also, which is csv in our case

  • View code of mapping:



  • Now add assign activity


  • Name it DecodeReportBytes


  • Use decodeBase64ToReference to decode report bytes to reference type. Click on Validate and then Close button



  • Add stage file action

  • Give it a name "ReadDecodedBytes"

  • Choose File Operation as "Read Entire File" 
  • Set Configure File Reference as "Yes"

  • Specify file reference as below


  • Select structure of file content as Sample delimited document (e.g. CSV)

  • Choose the sample file and give Record and RecordSet names:


  • Click Done button



  • Edit the mapper for GetInput


  • Add the tracking variable


  • Activate and test the integration now


Comments

Post a Comment