Technology Stack - EBS (MOSC)

MOSC Banner

fnd_user_resp_groups_direct table query

edited Oct 19, 2018 6:09AM in Technology Stack - EBS (MOSC) 6 commentsAnswered

I am trying to write an SQL query to pull out users and their responsibilities in one master report, rather than having to run endless reports in the application itself.

I noticed in fnd_user_resp_groups_direct there is a start_date and end_date column. This table (could be a view actually) joins to fnd_user on user_id column. Does the start_date and end_date column in the fnd_user_resp_groups_direct table represent the start and end date that user was granted the responsibility, and the responsibility removed from the user, respectively, or if not - what do the start and end dates represent in that table. If it is a view, I would like to see which table its pulling those fields from, and the question remains - what do they represent.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center