Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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 -
Could you please provide the solution that you implemented. Working on the same issue.
0 -
Hi @Sourav_Mondal I like your solution for BIP. Any idea how fusionapps_request_id get value of current ESS job ID?
0