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

Click Here

Comments

Post a Comment

Popular posts from this blog

Importance of Incremental Data in Oracle Fusion

-
 What is incremental data? Incremental Data Loads ----------------------- If you are sending employee data to a third-party payroll provider on every Friday, we don’t want to send all employees instead we only want the ones who changed current week. In this scenario, "LAST_UPDATE_DATE" column in the table plays vital role. LAST_UPDATE_DATE tells us when the record was physically saved. */ --Examples: ------------------------------- select count(1) from ( Select  papf.person_number, ppnf.FULL_NAME from  per_all_people_f papf, per_person_names_f ppnf WHERE 1=1 and papf.person_id=ppnf.person_id  and papf.LAST_UPDATE_DATE >=sysdate-7 --(Incremental) and ppnf.NAME_TYPE='GLOBAL' and sysdate between papf.EFFECTIVE_START_DATE and papf.EFFECTIVE_END_DATE and sysdate between ppnf.EFFECTIVE_START_DATE and ppnf.EFFECTIVE_END_DATE ) Result:  55 Records(Only Changed Records in current week) --------------------------------- select count(1) from ( Select  papf.person_n...
Read more

Mastering Parameters in Oracle Fusion BI Publisher

-
Mastering Parameters in Oracle Fusion BI Publisher: Mandatory, Optional, and "All" Logic When building Data Models in Oracle Fusion, how you handle parameters determines the user experience and report performance. Here is the definitive syntax guide: 1. Mandatory Parameters Use this when a value must be provided for the report to run. Syntax: AND column =:parameter Example: AND Person_Number = :p_Person_Number 2. Optional Parameters (The "All" Logic) Use this to allow users to leave a field blank or select "All" to see all records. Syntax (Recommended):  AND (:parameter IS NULL OR column = :parameter) Example: AND (:p_Person_Number IS NULL OR Person_Number = :p_Person_Number) Note: Using NVL is common but can be slower on large datasets as it may bypass indexes. 3. Multi-Select Parameters Use this when the user can select multiple values from a list. Syntax: AND (column IN (:parameter) OR 'All' IN (:parameter)) Example: AND (Person_Number IN (:p_Pe...
Read more

REST Web Service in Oracle Fusion to manage Banks

-
 REST Web Service  ================= Rest Resources Resources would have 5 end-points(methods) usually.  Ex: Create a Bank Read-Get a/all Banks Update Bank Delete a Bank Fusion Navigation for managing Banks  Setup and Maintenance Tasks Global Tasks Manage Banks Get All Banks  /fscmRestApi/resources/11.13.18.05/cashBanks https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks Get a specific Bank  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Create a Bank  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks patch  Update  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Put https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Delete  https://fa-eubg-saas...
Read more