FND_GLOBAL.APPS_INITIALIZE in Oracle Apps R12

FND_GLOBAL.APPS_INITIALIZE in Oracle Apps R12

FND_GLOBAL.APPS_INITIALIZE is used for initializing the session before calling any public or private API's in Oracle Ebusiness suite. 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. 

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


l_user_id is the fnd user ID.
l_resp_id is the responsibility ID
l_resp_appl_id is the responsibility application ID.


Query to get the user id, responsibility id and responsibility application id.

select fnd.user_id ,
       fresp.responsibility_id,
       fresp.application_id
from   fnd_user fnd
,      fnd_responsibility_tl fresp
where  fnd.user_name = 'SSPATIL'
and    fresp.responsibility_name = 'Order Management Super User';


or

fnd_global.apps_initialize( user_id => FND_GLOBAL.USER_ID,
                                            resp_id => FND_GLOBAL.RESP_ID,
                                            resp_appl_id => FND_GLOBAL.RESP_APPL_ID);