Home » SQL & PL/SQL » SQL & PL/SQL » SQL to find out OF responsibilities (Oracle Financials 11i)
SQL to find out OF responsibilities [message #360247] Thu, 20 November 2008 03:28 Go to next message
ehspacl
Messages: 2
Registered: November 2008
Junior Member
Not sure if i'm posting in the right place as it's my first post. but here goes.
I'm trying to find the right sql statement to get all the usser responsibilities out of Oracle Financials. I know i can use the apps to see individual users but some numpty in Fiance wants a list of all users and there responsibilites from the database. and to be honest i'm a little stuck. i know i need to look in the applsys scheme. Users are in fnd_user but from there i'm lost as to which tables hold a list of responsibilites.
Can anyone help?
Thanks in advance
Paul
Re: SQL to find out OF responsibilities [message #360256 is a reply to message #360247] Thu, 20 November 2008 03:51 Go to previous messageGo to next message
tarmenel@gmail.com
Messages: 18
Registered: November 2008
Junior Member
select * from fnd_user_resp_groups fur

this may also be useful
SELECT fav.application_name, frv.responsibility_key, frv.responsibility_name
FROM   fnd_responsibility_vl frv, fnd_application_vl fav
WHERE  fav.application_id = frv.application_id
Re: SQL to find out OF responsibilities [message #360263 is a reply to message #360247] Thu, 20 November 2008 04:05 Go to previous message
ehspacl
Messages: 2
Registered: November 2008
Junior Member
Many thanks for the quick response.

fnd_user_resp_groups has pushed me in the right direction, all i need to do now is decode the id's for meaningful names.

The second sql you gave me returned no rows, but will have a look at it again.

Cheers
Previous Topic: Connect by not looping
Next Topic: Finding non-numeric values
Goto Forum:
  


Current Time: Mon Feb 17 04:03:37 CST 2025