How to List Responsibility And Request Group in Oracle Applications 11i

   Use following SQL Report to list responsibilities and attached request groups. In oracle apps Users submit concurrent request based on the Request group assigned to thier responsibility.

COLUMN responsibility_name format a40 heading "Responsibility Name"
COLUMN request_group_name format a40 heading "Request Group Name"
COLUMN description format a60 heading "Request Group Detail"
BREAK on responsibility_name SKIP 1 ON request_group_name SKIP 1
SET feedback off
SET linesize 1000
SELECT 'Report Date: ' SYSDATE FROM DUAL;
SELECT frv.responsibility_name,
frg.request_group_name,
frg.description
FROM fnd_request_groups frg, fnd_responsibility_vl frv
WHERE frv.request_group_id = frg.request_group_id
ORDER BY responsibility_name;


Use Following SQL report to list Responsibilities, Request Group and Concurrent requests for each Request Group.


COLUMN responsibility_name format a40 heading "Responsibility Name"
COLUMN request_group_name format a40 heading "Request Group Name"
COLUMN DESCR format a60 heading "Request Group Detail"
COLUMN user_concurrent_program_name format a60 heading "Concurrent Program"
COLUMN Description format a60 heading "Concurrent Program Detail"
BREAK on responsibility_name SKIP 1 ON request_group_name SKIP 1 on DESCR
SET feedback off
SET linesize 1000
SELECT 'Report Date: ' SYSDATE FROM DUAL;
SELECT frv.responsibility_name, frg.request_group_name,
frg.description descr, fcpv.user_concurrent_program_name,
fcpv.description
FROM fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_vl fcpv,
fnd_responsibility_vl frv
WHERE frgu.request_unit_type = 'P'
AND frgu.request_group_id = frg.request_group_id
AND frgu.request_unit_id = fcpv.concurrent_program_id
AND frv.request_group_id = frg.request_group_id
ORDER BY responsibility_name, frg.request_group_name, frg.description

How to List Reponsibilities for an User in Oracle Applications 11i

You can use following SQL Statments to list responsibities assigned to all users or to a particuler user instead of going to System Administrator Screen.


For All Users

SELECT UNIQUE fu.user_id "User ID",
fu.user_name "User Name",
frt.responsibility_name "Responsibility Name",
frv.description "Responsibility Detail",
fat.application_name "Application Name"
FROM fnd_user fu,
fnd_user_resp_groups furg,
fnd_application_tl fat,
fnd_responsibility_tl frt,
fnd_responsibility_vl frv
WHERE furg.user_id(+) = fu.user_id
AND furg.responsibility_application_id = fat.application_id
AND fat.application_id = frt.application_id
AND furg.responsibility_id = frt.responsibility_id
AND furg.responsibility_application_id = frv.application_id
AND furg.responsibility_id = frv.responsibility_id
ORDER BY fu.user_name,
fat.application_name,
frt.responsibility_name


For particuler User
 SELECT UNIQUE fu.user_id "User ID",
fu.user_name "User Name",
frt.responsibility_name "Responsibility Name",
frv.description "Responsibility Detail",
fat.application_name "Application Name"
FROM fnd_user fu,
fnd_user_resp_groups furg,
fnd_application_tl fat,
fnd_responsibility_tl frt,
fnd_responsibility_vl frv
WHERE furg.user_id(+) = fu.user_id
AND furg.responsibility_application_id = fat.application_id
AND fat.application_id = frt.application_id
AND furg.responsibility_id = frt.responsibility_id
AND furg.responsibility_application_id = frv.application_id
AND furg.responsibility_id = frv.responsibility_id
And fu.USER_NAME = &Username