Human Capital Management - EBS (MOSC)

MOSC Banner

EBS active users responsibility report

edited Apr 20, 2021 11:55AM in Human Capital Management - EBS (MOSC) 4 commentsAnswered

Hi team,

Each month we check current active users with their active responsibilities by using this query from Oracle database 12.1.0.2.0 :


SELECT 

 fu.user_name    "User name", frt.responsibility_name "Responsibility Name" ,

 furg.start_date   "Start Date" , fu.end_date "User End Date", furg.end_date "Resp End Date" ,

 fu.last_logon_date  "Last Logon Date", fr.responsibility_key "Responsibility key",

 fu.email_address   "Email Address", fu.description   "Description"  

FROM

 fnd_user_resp_groups_direct  furg, applsys.fnd_user    fu,

 applsys.fnd_responsibility_tl frt, applsys.fnd_responsibility  fr

WHERE furg.user_id = fu.user_id

 AND furg.responsibility_id = frt.responsibility_id

Tagged:

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