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 - How to Retrieve Email Attachments Using Microsoft Graph API: Automating Payment File Processing

Retrieving Email Attachments Using Microsoft Graph API: Automating Payment File Storage in Object Storage Use Case: A finance team needs t...