Initializing the session oracle Apps R-12
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.
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);
l_user_id : fnd user ID which will be utilized during the call.
l_resp_id : responsibility ID
l_resp_appl_id : responsibility application ID.
You can use either sysadmin or use some user who has all the above listed responsibilities or you can use your username.
You can get user id,responsibility_id and application_id from below query:
select fnd.user_id ,
fresp.responsibility_id,
fresp.application_id
from fnd_user fnd,
fnd_responsibility_tl fresp
where fnd.user_name = 'P_user_name'
and fresp.responsibility_name = 'P_Responsibility_name';
Another option to get the values from oracle front-end, login and open java forms and then go to below path :
Help > Diagnostics > Examine
and get the values from $profile session values.
