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.
