Run BI Report Web Service Multiple Parameter date format Oracle Fusion BI Report xmlpserver/services/v2/ReportService WSDL

 

Run BI Publisher Report WSDL Web Service with Multiple Parameter which includes date format in oracle fusion

We will use the below WSDL web service for Running the BI Publisher Report to extract the output in PDF.

https://e.oraclecloud.com/xmlpserver/services/v2/ReportService?wsdl

Create Data Model

Sql Query

select username,user_id,start_date,active_flag  from PER_USERS where user_id = nvl(:p_user_id,user_id) and trunc(start_date) = nvl(:p_start_date,trunc(start_date))

 

Parameter

p_user_id

p_start_date

Output from the Data Model

 

 

Save the Data model

/Custom/Human Capital Management/FusionReports/XXHRReportWEbSrv.xdm

Create the Report

 

Select the existing data model

Select the View List and Make sure the Output Formats as PDF selected as option.

 

Incase of updating the template delete the existing template and upload the new template.

 

Report Stored Path:

/Custom/Human Capital Management/FusionReports/XXHRReportWEbSrvReport.xdo

https://e.oraclecloud.com/xmlpserver/services/v2/ReportService?wsdl

Input Parameter value:

p_start_date     :  10-28-2019

p_user_id           : 100000000347128

Sample Payload for Multiple Report Parameters

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">
   <soapenv:Header/>
   <soapenv:Body>
      <v2:runReport>
         <v2:reportRequest>
            <v2:attributeFormat>pdf</v2:attributeFormat>
            <v2:parameterNameValues>
             <v2:listOfParamNameValues>
                  <!--Zero or more repetitions:-->
                  <v2:item>
                     <v2:name>p_user_id</v2:name>
                      <v2:values>
                        <!--Zero or more repetitions:-->
                        <v2:item>100000000347128</v2:item>
                      </v2:values>
                  </v2:item>
                  <!--Zero or more repetitions:-->
                  <v2:item>
                     <v2:name>p_start_date</v2:name>
                       <v2:values>
                          <!--Zero or more repetitions:-->
                          <v2:item>10-28-2019</v2:item>
                        </v2:values>
                  </v2:item>
               </v2:listOfParamNameValues>
              </v2:parameterNameValues>
            <v2:reportAbsolutePath>/Custom/Human Capital Management/FusionReports/XXHRReportWEbSrvReport.xdo</v2:reportAbsolutePath>
         </v2:reportRequest>
         <v2:userID>Mara</v2:userID>
         <v2:password>welcome1234</v2:password>
      </v2:runReport>
   </soapenv:Body>
</soapenv:Envelope>

 

 Initiate Web Services – Using SOAPUI Tool

No Need to Provide the authentication since Built-in web service payload element user id and password considers the authentication.

 

 

Copy the Base64 output result and put it in any online converter, it will provide the PDF output as below.

Download the PDF

 

 Any queries please comment below. 

If you want to Invoke OTBI Report web Service and want to pass multiple parameter, you can refer the below YouTube video.

https://youtu.be/w6HEURFGjVA