Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to pass ESS requestid to BIP report

Accepted answer
2893
Views
16
Comments
2»

Answers

  • Rank 2 - Community Beginner

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

  • Rank 1 - Community Starter

    @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

  • Rank 1 - Community Starter

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

    Thanks

    Vivek

  • Rank 1 - Community Starter

    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

  • Rank 2 - Community Beginner

    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!

Welcome!

It looks like you're new here. Sign in or register to get started.