Recently i come accross a requirement to capture the requestidof the concurrent with in the concurrent program session...Even i am aware of the FND_GLOBAL package...But it didnt strike'at first go.....so i am writing this article for people who are not even awarethat this package exists..
FND_GLOBAL package gives the most of the enviroment values
THis package should be used in database side only...use FND_PROFILE package to get these values in Forms.
1.FND_GLOBAL.USERID --Returns userid
2.FND_GLOBAL.APPS_INTIALIZEprocedure APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in number);
This is used to set the values userid and responsibilityid for a session
3.FND_GLOBAL.LOGIN_ID -Gives login id
4.FND_GLOBAL.CONC_LOGIN_ID--Not sure how to use this
5.FND_GLOBAL.PROG_APPL_ID--Concurrent program application id
6.FND_GLOBAL.CONC_PROGRAM_ID--Concurrent program id
7.FND_GLOBAL.CONC_REQUEST_ID (Server)This will give the concurrent request id of the program which is calling the plsql package..
ln_Request_id:=FND_GLOBAL.CONC_REQUEST_ID;
Thanks.
ReplyDeleteVery Informative.
I was looking for it
Thanx for the information...
ReplyDeleteToo useful :)
My login id value is always -1, when I use FND_GLOBAL.LOGIN_ID.
ReplyDeleteHow shall I retrieve the correct value.
Lots of Thanks in Advance.
This is so cool and the information contributes a lot to all people. Thanks for this post.
ReplyDeleteBy the way, what is FND?
ReplyDeleteThanks for giving us ideas on FND_Global Package. Thanks for this post.
ReplyDeleteI am glad that you shared this thought about FND. Keep on updating us.
ReplyDeleteI love this FND: Global Package. Thanks for sharing this information.
ReplyDeleteThanks for making us aware of this. Thank you very much for updating us.
ReplyDeletethanks for making us aware of this package. At least we are now informed.
ReplyDeleteUseless - where does the package live?
ReplyDeleteVery useful info for me..Keep on posting good stuff.. Thanks..
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete
ReplyDeleteRegards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.