Oracle Transactional Business Intelligence
ESS Schedule Process ID into OTBI
Obtaining ESS Schedule Process ID into OTBI data model
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.
Version (include the version you are using, if applicable):
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 : [email protected]
Here "12345" should be the ESSID and the rest after "-" would be the current USER ID.
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.