PostRank

2009/03/16

如何取得Concurrent Request ID?!

Oracle Report:
1. 宣告Number型態的User Parameter : P_CONC_REQUEST_ID
2. 在Before Report Trigger中加上: srw.user_exit( 'FND SRWINIT' )
3. 在After Report Trigger中加上 : srw.user_exit( 'FND SRWEXIT' )
4. P_CONC_REQUEST_ID中就放著目前的Concurrent request id

PL/SQL:
fnd_profile.value('CONC_REQUEST_ID')

SELECT fnd_global.conc_request_id  FROM dual ;

1 則留言:

匿名 提到...

Nice fill someone in on and this fill someone in on helped me alot in my college assignement. Say thank you you for your information.