Which responsibility can run this request?

Time to time when I’m doing some patching or configuration regarding documentation there is said: run request X with parameters Y or performing some configuration/upgrade tasks that automatically submits some requests but after review statuses there are some failed and need to be fixed and rerun. As apps DBA usually I have system administrator responsibility with SYSADMIN user account but eBS is built so that not always request is already assigned to system administrator responsibility and then I have edit request groups or add extra responsibility to SYSADMIN  role to be able to run the request. Of course  Oracle Forms can be used to perform search what is what but this can be very time consuming so I have written down some SQL that could save you some time.

  • Find responsibility which can run particular request.
select cp.concurrent_program_id,
cp.user_concurrent_program_name,
rt.responsibility_id,
rt.responsibility_name
from fnd_concurrent_programs_tl cp,
fnd_request_group_units rg,
fnd_responsibility re,
fnd_responsibility_tl rt
where 1 = 1
and rg.request_unit_id = cp.concurrent_program_id
and re.request_group_id = rg.request_group_id
and rt.responsibility_id = re.responsibility_id
and cp.language = 'US'
and cp.user_concurrent_program_name =
'Gather Schema Statistics';

To continue this topic there are some addition SQL that I’m using time to time about users and responsibilities, like:

  • Which responsibilities has been assigned to particular user
select u.user_id, u.user_name, r.responsibility_name
from fnd_user u, fnd_user_resp_groups g, fnd_responsibility_tl r
where 1 = 1
and u.user_id = g.user_id
and r.responsibility_id = g.RESPONSIBILITY_ID
and u.user_name = 'SYSADMIN';
  • Which users have specific responsibility
select  r.responsibility_name, u.user_id, u.user_name</pre>
from fnd_user u, fnd_user_resp_groups g, fnd_responsibility_tl r
where 1 = 1
and u.user_id = g.user_id
and r.responsibility_id = g.RESPONSIBILITY_ID
and r.responsibility_name = 'System Administrator';

Now there is baselines to find fastest and easiest way to assign needed responsibility for user or add request to request group and there is possibility to submit them without starting whole application_tier, only concurrent managers are needed to be started (CONCSUB).

This post is part of about how to reducing downtime on production systems or some mass jobs so it’s also very good to get knowledge and experience on these topcis:

  • MoS  How to Assign and Revoke Role/Responsibility to a User using a Standard API? [ID 373369.1], also lot of examples can be found with Google search on fnd_user_pkg.addresp
  • MoS How To Submit A Concurrent Request Using CONCSUB Syntax [ID 457519.1]
  • MoS How to Submit NULL Parameters VIA Concsub [ID 1017746.6]
How to Assign and Revoke Role/Responsibility to a User using a Standard API? [ID 373369.1]
Advertisements
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: