ESS Schedule Process ID into OTBI

dbudd

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

Gaurav Bharadwaj-Oracle

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

dbudd

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 

Neha_Naik004

@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