FND_GLOBAL.APPS_INITIALIZE
beginfnd_client_info.set_org_context(l_org_id);
end;
---------------------
l_org_id := fnd_profile.VALUE('ORG_ID');
mo_global.init ('ONT');
mo_global.set_policy_context('S',l_org_id);
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 is the fnd user ID which will be utilized during the call.
- l_resp_id is the responsibility ID
- l_resp_appl_id is the responsibility application ID.
For SYSADMIN, utilize the following query to get the respective values
select fnd.user_id ,
fresp.responsibility_id,
fresp.application_id
from fnd_user f
, fnd_responsibility_tl res
where f.user_name = 'SYSADMIN'
and res.responsibility_name = 'Oracle Inventory';
Free Webinar : Oracle E-Business Suite - Salesforce.com Integration via Oracle's API on Aug 26th, 2015 at 3PM EST.
ReplyDeleteVisit: http://blog.optiosys.com