Tuesday, April 11, 2017

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

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...