[Report]取得Concurrent_request_id

get 取得 Oracle report Concurrent request_id

宣告User Parameter(P_CONC_REQUEST_ID) number

新增srw.user_exit('FND SRWINIT');在Before Report Trigger

新增srw.user_exit('FND SRWEXIT');在After Reporty Trigger

P_CONC_REQUEST_ID 就會有目前的Concurrent Request ID

PL/SQL:

fnd_profile.value('CONC_REQUEST_ID')

SELECT fnd_global.conc_request_id FROM dual;