SOAP Payload to Run a BI Publisher Report on Oracle ERP Cloud

Oracle has provided a webservice ExternalReportWSSService with “runReport” Operation which helps to run a report which is on BIP of Oracle ERP Cloud and get the output in base64 format. Below is the sample payload.

Service WSDL URL: https://servername/xmlpserver/services/ExternalReportWSSService?WSDL Operation: runReport

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:attributeFormat>csv</pub:attributeFormat>
			<!-- Flatten XML should always be false when we have XML type of output to display the XML tags as mentioned in BIP Data Model and display XML structure in as expected format -->
            <pub:flattenXML>false</pub:flattenXML>
            <pub:parameterNameValues>
				  <!--1st Parameter of BIP Report-->	
                  <pub:item>
                  <pub:name>p_from_date</pub:name>
                  <pub:values>
                      <pub:item>10-01-2019</pub:item>
                  </pub:values>
                  </pub:item>
				  <!--2ns Parameter of BIP Report-->
                  <pub:item>
                  <pub:name>p_to_date</pub:name>
                  <pub:values>
                      <pub:item>10-15-2019</pub:item>
                  </pub:values>
                  </pub:item>
            </pub:parameterNameValues>
            <pub:reportAbsolutePath>/Custom/Finacials/Payables/XX Vendor Outbound Report.xdo</pub:reportAbsolutePath>
			<!-- Setting sizeOfDataChunkDownload to -1 will return the output to the calling client -->
            <pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>
         </pub:reportRequest>
      </pub:runReport>
   </soap:Body>
</soap:Envelope>

Response:
Here is the sample response output. Output of the report is encoded in base64 format.

<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
   <env:Header/>
   <env:Body>
      <ns2:runReportResponse xmlns:ns2="http://xmlns.oracle.com/oxp/service/PublicReportService">
         <ns2:runReportReturn>
            <ns2:reportBytes>U1VQUExJRVJfTkFNRSxTVVBQTElFUl9OVU1CRVIsVEFYX0lELEVNQUlMX0FERFJFU1MsTEFTVF9OQU1FLEZJUlNUX05BTUUsUEhPTkVfRkFYLFBIT05FX01PQklMRSxQSE9ORV9XT1JLCjFfVGVzdF9TdXBwbF9TaGFpbCwxMDA3MSw5ODc2NTQzMjAsdGVzdDFAdGVzdC5jb20sMV9UZXN0X0xhc3QsMV9UZXN0X1NoYWlsX0NvbnRhY3QsbnVsbCw1NDMtNDM0MzQzNTQsMTIzLTEyMzQzCg</ns2:reportBytes>
            <ns2:reportContentType>text/plain;charset=UTF-8</ns2:reportContentType>
            <ns2:reportFileID xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
            <ns2:reportLocale xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
            <ns2:metaDataList xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
         </ns2:runReportReturn>
      </ns2:runReportResponse>
   </env:Body>
</env:Envelope>

SOAP Payload to Run a BI Publisher Report on Oracle ERP Cloud

For Further Reading