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

OIC XSLT: Execute Only When At Least One Field Has Value and None Are Blank

๐Ÿ”ท OIC XSLT: Validate Fields Before Executing Logic ๐Ÿ”น Requirement Fields: field1, field2, field3, field4, field5 ✔ Execute only when: At le...