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

Shailender Thallam

5 years ago

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:


   
   
      
         
            csv
			
            false
            
				  	
                  
                  p_from_date
                  
                      10-01-2019
                  
                  
				  
                  
                  p_to_date
                  
                      10-15-2019
                  
                  
            
            /Custom/Finacials/Payables/XX Vendor Outbound Report.xdo
			
            -1

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


   
   
      
         
            U1VQUExJRVJfTkFNRSxTVVBQTElFUl9OVU1CRVIsVEFYX0lELEVNQUlMX0FERFJFU1MsTEFTVF9OQU1FLEZJUlNUX05BTUUsUEhPTkVfRkFYLFBIT05FX01PQklMRSxQSE9ORV9XT1JLCjFfVGVzdF9TdXBwbF9TaGFpbCwxMDA3MSw5ODc2NTQzMjAsdGVzdDFAdGVzdC5jb20sMV9UZXN0X0xhc3QsMV9UZXN0X1NoYWlsX0NvbnRhY3QsbnVsbCw1NDMtNDM0MzQzNTQsMTIzLTEyMzQzCg
            text/plain;charset=UTF-8

For Further Reading