Use of FND_GLOBAL.APPS_INITIALIZE

FND_GLOBAL.APPS_INITIALIZE is used for initializing the session before calling any public or private API's in Oracle Ebusiness suite. 


- Use the API FND_GLOBAL.APPS_INITIALIZE to set the applications context in standalone sessions that were not initialized through normal means. 


- Typically, you would use this API in external custom programs that are establishing their own connections.


- Its not required for all the API's but its recommended that you set this profile before making any calls to either private or public API.




- Listed below is a sample call to FND_GLOBAL.APPS_INITIALIZE function


fnd_global.APPS_INITIALIZE(user_id=>l_user_id,
resp_id=>l_resp_id,
resp_appl_id=>l_resp_appl_id);


1. l_user_id is the fnd user ID which will be utilized during the call.
2. l_resp_id is the responsibility ID
3. l_resp_appl_id is the responsibility application ID.


- This procedure sets up global variables and profile values in a database session. 


- Call this procedure to initialize the global security context for a database session.


- You can also use this procedure to set up a database session for manually testing application code using SQL*Plus.