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
ESS Schedule Process ID into OTBI

Summary:
Obtaining ESS Schedule Process ID into OTBI data model
Content (required):
Hi all,
Has anybody every seen or done getting the ESS “Scheduled Process” request ID into a BI OTBI report? Also please note that I cannot change the ESS process to add any new ESS parameter, cause it is a standard Oracle report (Print Receivables Transactions).
Similarly I could use :xdo_user_name in the SQL data model of the BI to get me the username ran the ESS job, but I cannot find documented anything to get the ESS process ID.
Thanks
Daryl
Version (include the version you are using, if applicable):
Cloud 21D
Answers
-
If you are running/invoking the BI report via an ESS job, you could use the following function to retreive the ESSID.
(select SYS_CONTEXT( 'USERENV', 'CLIENT_IDENTIFIER' ) C_USER_NAME from dual) CURR_USER
This will return something like this : ess12345-abc.xyz@oracle.com
Here "12345" should be the ESSID and the rest after "-" would be the current USER ID.
Best Regards,
Gaurav
1 -
Thanks Gaurav!
Colleague found another way, each OTBI run from ESS gets a parameter named fusionapps_request_id, this can be seen as a parameter in the report job history.
This can be put in the data model sql written as :fusionapps_request_id and the output will receive the ESS request ID.
Thank you
Daryl
1 -
@dbudd : Could you please let me know how fusionapps_request_id be used as a report parameter? I was able to add it in as a dataset and access it inside the datamodel, however, I wanted to understand how this can be passed in report parameter. Please let me know.
Thanks!
Neha
0