Adding custom TOP in R12

Recently I tried to add new custom top to my R12 instance. In 11i all I had to do is to add my top to adovars.env file, but when I did it on R12 instance it didn't work. After some research I managed to add my top by running the following:

echo "xxpck   $APPL_TOP" >> $APPL_TOP/admin/topfile.txt

run autoconfig

enjoy!!!

Using PL/SQL to generate Apps Initialize command

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;