You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
2
Views
0
Comments

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

https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/reportservice.htm#BIPDV824

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 “

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!