Tuesday, March 21, 2023

Oracle ERP - Soap UI - Run BI report using ExternalReportWSSService from Soapui

Usecase: Here, we will show how to run BI report from SOAP UI tool.

We have to call the following wsdl format to call the BI report:

https://<your oracle cloud application instance domain>/xmlpserver/services/ExternalReportWSSService?WSDL


Steps to follow:

File >> New SOAP Project


Add the wsdl and a project name.


runReport >> Request 1


Put the following data :
reportAbsolutePath
sizeOfDataChunkDownload
ParameterNameValues
Name: p_load_request_id
values >> item : <id>


Add basic Authrization > add provide user and password details and run.





See we got the response which is in base64 decoded format.

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...