How to pass ESS requestid to BIP report

Neha_Naik004 · July 8

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

Ram Murthy Buddhiraju · July 10

@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 · July 13

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 · July 23

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 · July 23

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!

Sourav_Mondal · August 27

Solution :

Create a parameter in BIP datamodel with the name as is : fusionapps_request_id
You can give any display name. This parameter can be mapped to any third party request.
In the master ESS job , don't add this parameter.

Oracle Analytics Cloud and Server

Categories

How to pass ESS requestid to BIP report

Answers