How to run BIP Report in Oracle HCM Cloud
How to run BI Publisher (BIP) report via SOAP UI
=====================================
Step-by-step instructions
-------------------------
Step1: Locate WSDL URL.
Every Oracle Fusion instance follows a standard URL pattern for the BIP SOAP service.
Take Fusion instance URL https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/
Append the following path to it:
xmlpserver/services/ExternalReportWSSService?WSDL
Full URL to run BIP report in Fusion from SOAP UI: https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/xmlpserver/services/ExternalReportWSSService?wsdl
Phase 2: Setting up SOAP UI
Open SOAP UI.
Click on File > New SOAP Project.
Or Click on SOAP
Project Name:"BIP_Run_Test01"
Paste the URL which constructed in Step1.
Click OK. This will load all available operations (runReport, scheduleReport,submitReport.. etc.).
Phase 3:
Choose runReport and click on Request1
In the next window, click on Auth,
Enter Fusion instance User Name and password.
Step4: Constructing the runReport
Open Request 1.
We need to fill the <reportRequest> block.
Key XML Elements:
<reportAbsolutePath>: The path to the report in the Catalog.
<sizeOfDataChunk>: Set to -1 to get all data.
<parameterNameValues>: Enter the parameters for the Report
Sample Request Payload:
<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:parameterNameValues>
<pub:item>
<pub:name>P_PERSON_NUMBER</pub:name>
<pub:values>
<pub:item>72</pub:item>
</pub:values>
</pub:item>
<pub:item>
<pub:name>P_START_DATE</pub:name>
<pub:values>
<pub:item>02-01-2026</pub:item>
</pub:values>
</pub:item>
<pub:item>
<pub:name>P_END_DATE</pub:name>
<pub:values>
<pub:item>02-10-2026</pub:item>
</pub:values>
</pub:item>
</pub:parameterNameValues>
<pub:reportAbsolutePath>/Custom/Feb_Reports/Person_Info_Report.xdo</pub:reportAbsolutePath>
<pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>
</pub:reportRequest>
</pub:runReport>
</soap:Body>
</soap:Envelope>
Step5: Executing and Reading Results
Click the Green Play Arrow in SOAP UI to execute the process.
The response will return a long string of garbled text in the <reportBytes> tag. This is in Base64 encoded data.
Step6:To see the data:
Copy the content inside the <reportBytes> tag.
Paste it in Notepad++
select the all the text, click on Plugins>choose MIME Tools>Choose Base64 Decode.
Watch it on YouTube
Comments
Post a Comment