Find List of Responsibilities For a Request Set in Oracle Apps R12

SELECT frt.responsibility_name,
  frg.request_group_name,
  frgu.request_unit_type,
  frgu.request_unit_id,
  fcpt.user_request_set_name,
  fr.responsibility_id,
  fr.application_id
FROM apps.fnd_Responsibility fr,
  apps.fnd_responsibility_tl frt,
  apps.fnd_request_groups frg,
  apps.fnd_request_group_units frgu,
  apps.fnd_request_Sets_tl fcpt
WHERE frt.responsibility_id    = fr.responsibility_id
AND frg.request_group_id       = fr.request_group_id
AND frgu.request_group_id      = frg.request_group_id
AND fcpt.request_set_id        = frgu.request_unit_id
AND fcpt.user_request_set_name = 'Import Item Organization Assignment';

What is a Responsibility in Oracle Apps?

Responsibility is a collection of different modules that the user is to access.

OR

Responsibility is the collection of menus, request security groups, and data groups.

  Menus: a collection of forms is nothing but menus (Mandatory)

  Request security groups: a collection of programs. (Optional)

  Data groups: a group of modules to be made accessible by the user through (Mandatory)

  Function & Menu: Exclusion (Optional)

          

Define a new Responsibility:

           System admin-> Security: Responsibility -> define

                                        Security: user-> define

Query To Find Concurrent Program Attached To a Responsibility

SELECT fcpt.user_concurrent_program_name,
  frt.responsibility_name,
  frg.request_group_name
FROM fnd_Responsibility fr,
  fnd_responsibility_tl frt,
  fnd_request_groups frg,
  fnd_request_group_units frgu,
  fnd_concurrent_programs_tl fcpt
WHERE frt.responsibility_id           = fr.responsibility_id
AND frg.request_group_id              = fr.request_group_id
AND frgu.request_group_id             = frg.request_group_id
AND fcpt.concurrent_program_id        = frgu.request_unit_id
AND fcpt.user_concurrent_program_name = '&conc_program_name';

Query to list all the responsibilities attached to a user

SELECT fu.user_name,
  fr.responsibility_name,
  furg.start_date,
  furg.end_date
FROM fnd_user_resp_groups_direct furg,
  fnd_user fu,
  fnd_responsibility_tl fr
WHERE upper(fu.user_name)  =upper(:user_name)
AND furg.user_id           = fu.user_id
AND furg.responsibility_id = fr.responsibility_id
AND fr.language            = userenv('lang');