How to run a Fusion BIP report with WS in synchronous mode?

Hi,

In this post, I will show you how to run a BIP report with WS in synchronous mode.

Here are the steps you can try -

1. Open the Fusion BIP WSDL (ExternalReportWSSService?wsdl) in your preferred tool.  

URL - https://podURL/xmlpserver/services/ExternalReportWSSService?wsdl

2. Construct the request payload 

Here is my test payload for a custom BIP report -

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">

   <soap:Header/>

   <soap:Body>

      <pub:runReport>

         <pub:reportRequest>

            <pub:attributeFormat>csv</pub:attributeFormat>

            <pub:reportAbsolutePath>/Custom/UserRPT.xdo</pub:reportAbsolutePath>

            <pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>

         </pub:reportRequest>

      </pub:runReport>

   </soap:Body>

</soap:Envelope>

3. Run request in SoapUI. BIP report output encoded in BASE64 is returned in the response payload like below,

Hope you find this post helpful, and stay healthy.

Thanks,

Adam Liu

Reference Document - 

Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications (Doc ID 2086077.1)