Where can I find resp associated to profiles

[warne]

Hi,

I have assigned a specific responsibility to a profile using

SYSTEM ADMINISTRATION -> PROFILE -> DEFINE

In which database tables can I find these responsibility assigned to profiles

or is there any seeded API that does this job.

Thanks
Warne

[oteixeira]

Hello.

You can use this query:

Code: Select all

 select frv.responsibility_name,fo.profile_option_name
  from fnd_user fu,
      fnd_profile_options_vl fo,
      fnd_user_resp_groups fug,
      fnd_responsibility_vl frv,
      fnd_profile_option_values fpv
   where fpv.profile_option_id = fo.profile_option_id
   and fo.user_profile_option_name = <your user_profile_option_name>
   and fpv.level_value = fug.responsibility_id
   and fug.responsibility_id = frv.responsibility_id
   and fug.user_id = fu.user_id

Note that <your user_profile_option_name> is the name in the leftmost column of the System Profile Option window.

Octavio