Tuesday, April 3, 2012

Deleting concurrent program,migration of Concurrent program and Adding of Concurrent program to request group from back-end.

Hi,
Apps DBA do lot of System administration tasks from Front end E-business suite,but some times we can also do from backend like below:


1.Concurrent program clear script:

begin
apps.fnd_program.delete_program('TESTAPP_PMT_PROCESS','TESTAPP');
commit;
end;
/

2.Migrate the Concurrent program LDT from APP1 to APP2 :

Download APP1:
FNDLOAD apps/apps_password O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct concprg_TESTAPP_pmt_process.ldt PROGRAM APPLICATION_SHORT_NAME="TESTAPP" CONCURRENT_PROGRAM_NAME="TESTAPP_PMT_PROCESS"

Upload APP2:
FNDLOAD apps/apps_password O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct concprg_TESTAPP_pmt_process.ldt


3.Add ‘TESTAPP: PMT – Process’ to ‘TESTAPP Custom Request Group’ request group:

Following piece of code is used for adding Concurrent program to any request group from Pl/SQL:

SQL> SELECT NAME FROM V$DATABASE;

NAME
---------
TESTAPP

SQL> show user
USER is "APPS"

SQL> DECLARE
     BEGIN
     FND_PROGRAM.add_to_group
        (
        PROGRAM_SHORT_NAME  =>'TESTAPP: PMT – Process'
       ,PROGRAM_APPLICATION =>'TESTAPP: PMT'
       ,REQUEST_GROUP       =>'TESTAPP Custom Request Group'
       ,GROUP_APPLICATION   =>'TESTAPP Custom'
       ) ;
      commit;
    exception
      when others then
             dbms_output.put_line('Request Already exixts in this request group');
   END ;
    /

PL/SQL procedure successfully completed.

Hope it helps....

Enjoy Apps DBA learning...

Best regards,

Rafi.

No comments:

Post a Comment