Thursday, April 19, 2012

How to initialize apps

fnd_global.APPS_INITIALIZE(user_id=>0,--l_user_id,
                                                   resp_id=>20707,--l_resp_id,
                                                resp_appl_id=>201);--l_resp_appl_id);
                                               
                                               
                                                select fnd.user_id ,
       fresp.responsibility_id,
       fresp.application_id
from   fnd_user fnd
,      fnd_responsibility_tl fresp
where  fnd.user_name = 'SYSADMIN'
and    fresp.responsibility_name = 'Purchasing Super User';