Oracle Applications HOWTO: find program's responsibility

Go to Michael Dvorkin's user page

Prerequisites
E-Business Suite 11.5.9, 11.5.10 bnvkuyo

Steps to find program's responsibility
The following SQL gives a list of responsibilities you can use in order to submit a concurrent program:

select p.user_concurrent_program_name, rt.responsibility_name responsibility from FND_REQUEST_GROUPS g,         FND_REQUEST_GROUP_UNITS u,          FND_APPLICATION_TL a,          FND_APPLICATION_TL a1, FND_CONCURRENT_PROGRAMS_TL p,         FND_CONCURRENT_PROGRAMS p1, FND_RESPONSIBILITY r,         FND_RESPONSIBILITY_TL rt    where u.application_id = g.application_id and u.request_group_id = g.request_group_id and (u.request_unit_id = p.concurrent_program_id or u.request_unit_type = 'A') and u.unit_application_id = p.application_id and p.application_id = a.application_id and p.concurrent_program_id = p1.concurrent_program_id and g.application_id = a1.application_id and r.request_group_id = g.request_group_id and r.responsibility_id = rt.responsibility_id and rt.language = 'US' and p.language = 'US' and a.language = 'US' and a1.language = 'US' and p.user_concurrent_program_name like '%%' order by 1;

For example:

select p.user_concurrent_program_name, rt.responsibility_name responsibility from FND_REQUEST_GROUPS g,         FND_REQUEST_GROUP_UNITS u,          FND_APPLICATION_TL a,          FND_APPLICATION_TL a1, FND_CONCURRENT_PROGRAMS_TL p,         FND_CONCURRENT_PROGRAMS p1, FND_RESPONSIBILITY r,         FND_RESPONSIBILITY_TL rt    where u.application_id = g.application_id and u.request_group_id = g.request_group_id and (u.request_unit_id = p.concurrent_program_id or u.request_unit_type = 'A') and u.unit_application_id = p.application_id and p.application_id = a.application_id and p.concurrent_program_id = p1.concurrent_program_id and g.application_id = a1.application_id and r.request_group_id = g.request_group_id and r.responsibility_id = rt.responsibility_id and rt.language = 'US' and p.language = 'US' and a.language = 'US' and a1.language = 'US' and p.user_concurrent_program_name like '%Active Responsibilities%' order by 1;

Active Responsibilities	Implementation System Administration Active Responsibilities	Implementation Financials Active Responsibilities	Implementation Sales and Service Active Responsibilities	Implementation Human Resources Active Responsibilities	Implementation Manufacturing Active Responsibilities	Implementation Process Manufacturing Active Responsibilities	XNS System Administrator Active Responsibilities	System Administration Active Responsibilities	System Administrator

Known Issues
Go to Michael Dvorkin's user page