EBS Customizations (MOSC)

MOSC Banner

SQL Query to find when did the user last used his responsibilities

edited Nov 18, 2014 10:00AM in EBS Customizations (MOSC) 3 commentsAnswered

Hi,

By searching the community, have found the below query .

select fu.user_name,frt.responsibility_name,max(fl.Start_time)

From applsys.fnd_login_Responsibilities flr, fnd_user fu,

applsys.fnd_logins fl, fnd_responsibility_tl frt

where fl.login_id = flr.login_id

and fl.user_id = fu.user_id

and fu.user_name like '%RAMA%'

and frt.responsibility_id = flr.responsibility_id

and frt.language = 'US'

group by frt.responsibility_name,fu.user_name

order by Max(flr.start_time) desc;

But the above query is only giving the results only if the users have used the standard oracle forms.

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