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;
16 comments:
Thanks.
Very Informative.
I was looking for it
Thanx for the information...
Too useful :)
My login id value is always -1, when I use FND_GLOBAL.LOGIN_ID.
How 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.
By the way, what is FND?
Thanks for giving us ideas on FND_Global Package. Thanks for this post.
I am glad that you shared this thought about FND. Keep on updating us.
I love this FND: Global Package. Thanks for sharing this information.
Thanks for making us aware of this. Thank you very much for updating us.
thanks for making us aware of this package. At least we are now informed.
Useless - where does the package live?
Very useful info for me..Keep on posting good stuff.. Thanks..
Regards
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.
Post a Comment