Scheduling BIP Report using SOAP Services?
Scheduling BIP Report using SOAP Services?

 1,164 total views

We can run the BI Reports ad-hoc, or schedule them to email/FTP at weekly/daily basis. However we will explore the option of scheduling the BIP Report using SOAP webservices.

SOAP WSDL: https://{hostname}/xmlpserver/services/v2/ScheduleService?wsdl

Sample: https://abcd-test.fa.us6.oraclecloud.com/xmlpserver/services/v2/ScheduleService?wsdl

Once we have the WSDL, we can use the SOAPUI to consume this WSDL and execute the scheduleReport request with the below payload.

<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:v2=”http://xmlns.oracle.com/oxp/service/v2″>
<soapenv:Header/>
<soapenv:Body>
<v2:scheduleReport>
<v2:scheduleRequest>
<v2:bookBindingOutputOption>false</v2:bookBindingOutputOption>
<v2:mergeOutputOption>false</v2:mergeOutputOption>
<v2:notifyHttpWhenFailed>false</v2:notifyHttpWhenFailed>
<v2:notifyHttpWhenSkipped>false</v2:notifyHttpWhenSkipped>
<v2:notifyHttpWhenSuccess>false</v2:notifyHttpWhenSuccess>
<v2:notifyHttpWhenWarning>false</v2:notifyHttpWhenWarning>
<v2:notifyWhenFailed>false</v2:notifyWhenFailed>
<v2:notifyWhenSkipped>false</v2:notifyWhenSkipped>
<v2:notifyWhenSuccess>false</v2:notifyWhenSuccess>
<v2:notifyWhenWarning>false</v2:notifyWhenWarning>
<v2:repeatCount>1</v2:repeatCount>
<v2:repeatInterval>0</v2:repeatInterval>
<v2:reportRequest>
<v2:attributeFormat>csv</v2:attributeFormat>
<v2:attributeLocale>en_US</v2:attributeLocale>
<v2:attributeTemplate>xt</v2:attributeTemplate>
<v2:byPassCache>true</v2:byPassCache>
<v2:flattenXML>false</v2:flattenXML>
<v2:parameterNameValues>
<v2:listOfParamNameValues>
<v2:item>
<v2:name>CONTENTID</v2:name>
<v2:values>
<v2:item>INPUTCONTENTID</v2:item>
</v2:values>
</v2:item>
</v2:listOfParamNameValues>
</v2:parameterNameValues>
<v2:reportAbsolutePath>/Custom/SM/TEST/REPORT.xdo</v2:reportAbsolutePath>
<v2:sizeOfDataChunkDownload>0</v2:sizeOfDataChunkDownload>
</v2:reportRequest>
<v2:saveDataOption>false</v2:saveDataOption>
<v2:saveOutputOption>true</v2:saveOutputOption>
<v2:scheduleBurstringOption>true</v2:scheduleBurstringOption>
<v2:schedulePublicOption>false</v2:schedulePublicOption>
<v2:startDate/>
<v2:useUTF8Option>false</v2:useUTF8Option>
<v2:userJobDesc>SampleJob</v2:userJobDesc>
<v2:userJobName>SampleJob</v2:userJobName>
</v2:scheduleRequest>
<v2:userID>*******</v2:userID>
<v2:password>*******</v2:password>
</v2:scheduleReport>
</soapenv:Body>
</soapenv:Envelope>

You can modify the Absolute Path of Report, Parameters, UserID, Password and submit the request.

If you have any questions, please feel free to reach out to me by posting in comments section.

If you are interested in learning Fusion Technical tools go through this post

If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply