top of page

Tags

Archive

Call Fusion BIP Report using Run report Service

In this Blog , I will Show you how to call a BIP report using run report service.


To Call a report .. you need a WSDL..


https://POD/xmlpserver/services/PublicReportService?WSDL


Sample Payload :


Operation : Run Report



<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
   <soapenv:Header/>
   <soapenv:Body>
      <pub:runReport>
         <pub:reportRequest>
            <pub:parameterNameValues>
               <!--Zero or more repetitions:-->
               <pub:item>
                  <pub:name>p_vendor_name</pub:name>
                  <pub:values>
                     <!--Zero or more repetitions:-->
                     <pub:item>Epson Printers</pub:item>
                  </pub:values>
               </pub:item>
            </pub:parameterNameValues>
            <!--<pub:attributeLocale>en-US</pub:attributeLocale>
            <pub:attributeTemplate>Simple</pub:attributeTemplate>-->
            <pub:reportAbsolutePath>/Custom/Financials/Payables/xx Invoice Spend Report.xdo</pub:reportAbsolutePath>
         </pub:reportRequest>
         <pub:userID>test.user2</pub:userID>
         <pub:password>******</pub:password>
      </pub:runReport>
   </soapenv:Body>
</soapenv:Envelope>

In the Above Payload , The red Represents the report Parameters , The Blue represents the Report Path and Instance Credentials.


Response :



<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <runReportResponse xmlns="http://xmlns.oracle.com/oxp/service/PublicReportService">
         <runReportReturn>
            <reportBytes>77u/UF9WRU5ET1JfTkFNRSxWRU5ET1JfTkFNRSxTRUdNRU5UMSxWRU5ET1JfU0lURV9DT0RFLENPVU5UX0lOVk9JQ0VTLENPVU5UX1BBSURfSU5WCiJFcHNvbiBQcmludGVycyIsIkVwc29uIFByaW50ZXJzIiwxMDAwMDAxMiwiU2hpcHBpbmcgU3RvcmUiLDAsMAo=</reportBytes>
            <reportContentType>text/plain;charset=UTF-8</reportContentType>
         </runReportReturn>
      </runReportResponse>
   </soapenv:Body>
</soapenv:Envelope>

The Blue Highlited data is your Encoded report output .

To Decode this you either need a Java library or for testing you can use a website utility like https://www.base64decode.org/.


Hope this Helps . Happy learning

290 views0 comments

Recent Posts

See All

When transactions are entered, Dynamic Insertion in Oracle Fusion General Ledger (GL) allows an organisation to automatically insert extra segments or values in the GL chart of accounts. This feature

Oracle Fusion Segment Security The General Ledger (GL) feature enables an organisation to restrict access to data in the GL depending on certain parts of the GL chart of accounts. A segment is a subse

Oracle Fusion General Ledger (GL) Cross-Validation Rules are used to assure the integrity and accuracy of data entered into the GL module. They are used to ensure that data submitted in the GL is cons

Other Posts you may Interested