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.

2 comments:

  1. There are many more benefits of pursuing CAPM Certification Training in USA It draws out the hidden skills and increase your market value that can be much beneficial for the future.

    ReplyDelete
  2. A smallish campaign with a homemade list would not be likely to yield much of a result. To achieve anything worthwhile, a much more aggressive effort is needed. Then, the age-old value analysis applies: projected earnings = margin on total projected sales - cost of campaign.

    ReplyDelete