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

Microsoft Excel - working with excel's lookup function

 Working... 📘 Working with Excel Lookup Functions 🔹 Microsoft Excel VLOOKUP() Function Searches for a value in the first column of a table...