Wikia

How To Wiki

Oracle Applications HOWTO: find program's responsibility

1,794pages on
this wiki
Talk0

Go to Michael Dvorkin's user page

Prerequisites Edit

E-Business Suite 11.5.9, 11.5.10 bnvkuyo

Steps to find program's responsibility Edit

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 '%<PROGRAM NAME>%'
   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 Edit

Go to Michael Dvorkin's user page

Around Wikia's network

Random Wiki