You don't need to enter the instance anymore to extract Apps Initialize command.
Just run the following code . Replace USERNAME_HERE by your username
declare
l_user_id fnd_user.user_id%type;
l_responsibility_id fnd_responsibility_tl.responsibility_id%type;
l_application_id fnd_responsibility_tl.application_id%type;
begin
select t.user_id
into l_user_id
from fnd_user t
where t.user_name = 'USERNAME_HERE';
select t.responsibility_id, t.application_id
into l_responsibility_id, l_application_id
from fnd_responsibility_tl t
where t.responsibility_name like 'RESPONSIBILITY_NAME_HERE' and
t.language = 'US';
fnd_global.apps_initialize(l_user_id,
l_responsibility_id,
l_application_id);
dbms_output.put_line('begin fnd_global.apps_initialize' ||
' (user_id => ' || l_user_id || ', resp_id => ' ||
l_responsibility_id || ', resp_appl_id => ' ||
l_application_id || '); end;');
end;
No comments:
Post a Comment