How to pass ESS requestid to BIP report - Page 2 — Oracle Analytics

Oracle Analytics Publisher

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
3216
Views
18
Comments
2»

Answers

  • Neha_Naik004
    Neha_Naik004 Rank 2 - Community Beginner

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

  • Ram Murthy Buddhiraju
    Ram Murthy Buddhiraju 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

  • vivek.clement
    vivek.clement 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

  • Ram Murthy Buddhiraju
    Ram Murthy Buddhiraju 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

  • Neha_Naik004
    Neha_Naik004 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!

  • User_9L97V
    User_9L97V Rank 1 - Community Starter

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

  • 2172023
    2172023 Rank 1 - Community Starter

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