begin
fnd_global.apps_initialize(&user_id,&resp_id,&resp_appl_id);
end;
Use below sql's to derive values used in apps_initialize.
or use below statement in your apps routine.
SELECT fnd_profile.value (‘USER_ID’) FROM dual;
SELECT fnd_profile.value (‘RESP_ID’) FROM dual;
SELECT fnd_profile.value (‘RESP_APPL_ID’) FROM dual;
fnd_global.apps_initialize(fnd_profile.value (‘USER_ID’) ,fnd_profile.value (‘RESP_ID’),fnd_profile.value (‘RESP_APPL_ID’) );
fnd_profile.value cannot be accessed from SQL. These values will get initialize / passed to a routine only from Oracle Apps.
If a stand alone program needed to be initialized, hard code values in apps_initialize.
Corresponding values can be found using below SQL
user_id
select user_id from fnd_user where user_name = <'user_name'>;
resp_id, resp_appl_id
select responsibility_id,application_id from fnd_responsibility_tl where responsibility_name = <'Your Resp Name'>
No comments:
Post a Comment