Concurrent programs which uses a value set

  SELECT fcpl.user_concurrent_program_name "Concurrent Program Name",

         fcp.concurrent_program_name "Short Name",

         fdfcuv.column_seq_num "Column Seq Number",

         fdfcuv.end_user_column_name "Parameter Name",

Instance Migration Scripts - Concurrent programs

--  Verify Concurrent Programs

  SELECT *

    FROM apps.fnd_concurrent_programs_vl

   WHERE user_concurrent_program_name = 'XYZ Price Utility Report'

ORDER BY user_concurrent_program_name;

--  Verify Concurrent Program is assigned  request set or not

SELECT fcpt.user_concurrent_program_name, fcpt.concurrent_program_id,

       frg.request_group_name

  FROM apps.fnd_concurrent_programs_tl fcpt,

       apps.fnd_request_group_units frgu,

       apps.fnd_request_groups frg

 WHERE frgu.request_unit_type = 'P'

   AND frgu.request_unit_id = fcpt.concurrent_program_id

   AND frgu.request_group_id = frg.request_group_id

   AND fcpt.user_concurrent_program_name LIKE 'abc%';

Add Concurrent program to request set from backend

FND_PROGRAM.ADD_TO_GROUP: The procedure is used to add a concurrent program to a request group. This procedure corresponds to the "Requests" region in the "Request Groups" window in System Administration.

Syntax:

procedure FND_PROGRAM.ADD_TO_GROUP

(program_short_name IN VARCHAR2,

program_application IN VARCHAR2,

request_group IN VARCHAR2,

group_application IN VARCHAR2);