SQL to find out OF responsibilities [message #360247] |
Thu, 20 November 2008 03:28  |
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 #360263 is a reply to message #360247] |
Thu, 20 November 2008 04:05  |
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
|
|
|