Categories
How to pass ESS requestid to BIP report
Answers
-
@kkounder : Can you please explain with an example how this can be achieved?
0 -
@Neha_Naik004 - If you are looking to derive the current running request id of the BIP report in the query of the BIP report itself, then you can use FND_JOB.REQUEST_ID. Example below. Please see if this is what you are looking for
SELECT parentrequestid
FROM ess_request_history
WHERE requestid = fnd_job.request_id2 -
SELECT FND_JOB.REQUEST_ID REQUEST_ID FROM .. works for me when the BI report is submitted as an ESS job.
Thanks
Vivek
0 -
If you are looking for current running request id of the BIP report in the query of the BIP report itself, then you can use FND_JOB.REQUEST_ID. This is equivalent to FND_GLOBAL.CONC_REQUEST_ID in Oracle EBS. Example below. Please see if this is what you are looking for
SELECT parentrequestid
FROM ess_request_history
WHERE requestid = fnd_job.request_id0 -
Hi @Ram Murthy Buddhiraju, Thanks for your response.
My question was on how can we pass/access the parentrequestid in ESS job parameter. Below query works well inside the data model and gives correct parentrequestid. However, I wanted to understand if the request id can be passed as a parameter to a third-party application.
Thanks!
0
