How to pass ESS requestid to BIP report

Neha_Naik004 · Jul 8, 2024 9:57AM

@kkounder : Can you please explain with an example how this can be achieved?

Ram Murthy Buddhiraju · Jul 10, 2024 1:25PM

@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_id

vivek.clement · Jul 13, 2024 9:31AM

SELECT FND_JOB.REQUEST_ID REQUEST_ID FROM .. works for me when the BI report is submitted as an ESS job.

Thanks

Vivek

Ram Murthy Buddhiraju · Jul 23, 2024 2:27PM

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_id

Neha_Naik004 · Jul 23, 2024 2:46PM

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!

User_9L97V · Jul 3, 2025 10:52AM

https://community.oracle.com/products/oracleanalytics/discussion/comment/41312#Comment_41312

Could you please provide the solution that you implemented. Working on the same issue.

2172023 · Aug 4, 2025 9:57PM

Hi @Sourav_Mondal I like your solution for BIP. Any idea how fusionapps_request_id get value of current ESS job ID?

Oracle Analytics Publisher

Categories

How to pass ESS requestid to BIP report

Answers