How to create Request Group in oracle apps

Step 1:-

Go to System Admin


Step 2:-



Create Request Group and attach in Responsibility

/* Formatted on 12/19/2014 1:02:29 PM (QP5 v5.115.810.9015) */
SELECT   *
  FROM   FND_REQUEST_GROUP_UNITS
 WHERE   TRUNC (CREATION_DATE) = TRUNC (SYSDATE)

/* Formatted on 12/19/2014 1:02:12 PM (QP5 v5.115.810.9015) */
SELECT   *
  FROM   FND_REQUEST_GROUPS
 WHERE   TRUNC (CREATION_DATE) = TRUNC (SYSDATE)

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