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
set attributeFormat tag = xml
pass reportAbsolutePath as path with bip report name . xdo
example
reportAbsolutePath= /Custom/Financials/InvoicePayment Extract Report.xdo
and sizeOfDataChunkDownload = -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
