Add a Concurrent Program to a Request Group

Add a Concurrent Program to a Request Group

Background:
Add a concurrent program to a request group through API/Script

Script:

BEGIN
fnd_program.add_to_group(
        PROGRAM_SHORT_NAME  => 'XX_SHORTNAME',
        PROGRAM_APPLICATION => 'XX_PROG_APPL',
        REQUEST_GROUP       => 'All Reports',
        GROUP_APPLICATION   => 'SQLAP'
      );
commit;
END;
/

Explanation of the Parameters:

program_short_name  = Short name of the program. (e.g. FNDSCRMT)
program_application   = Application of the program. (e.g. 'FND')
request_group            = Name of request group
group_application       = Application of the request group
 
 
 
 

No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...