Recover the invoice AP report (PDF) using the web service

Apr 3, 2024 8:49AM

Summary:

In this document (Doc ID 2253618.1) is mention how to recover the PDF:

Please use the below JobID to get the BIP JobID and use this in the Web service

Query to Get JobID

=============================

select requestid "ESS Request ID", value "BI JobID" from fusion_ora_ess.request_property

where name='outputOverrideParameter'

and requestid ='&requestid';

Steps to get the PDF

1. Given Query is run in BI to get the “JobInstanceId” from the ESSRequestID.

2. With the jobInstanceId, call is been made to “getScheduledReportOutputInfo()” webservice which returns the “JOBOUTPUTID”.

3. With this “joboutputId” another webservice call has to be made to “