BI Publisher web service run report example

In this post, let’s see a BI Publisher web service run report example using the web service called ExternalReportWSSService.

The Oracle Fusion Cloud OTBI reports data can be fetched using web service calls using the ERP integration service.

The service WSDL is of the format

https://*******oraclecloud.com/xmlpserver/services/ExternalReportWSSService?wsdl

Use the RunReport operation

set attributeFormat tag = xml

pass reportAbsolutePath as path with bip report name . xdo
example
reportAbsolutePath= /Custom/Financials/InvoicePayment Extract Report.xdo

and sizeOfDataChunkDownload = -1
image 2 BI Publisher web service run report example 1

The output of the SOAP UI call would be in report bytes . To read that you would need to decode the base 64 report bytes format into XML and process the XML data based on your need. Generally this is a common requirement in OIC integration calling BIP report web service.

You may like Bursting in BIP

More fusion apps tech

We will be happy to hear your thoughts

      Leave a reply

      Cloud Technologies Blog
      Logo
      Enable registration in settings - general
      Compare items
      • Total (0)
      Compare
      0
      Shopping cart