SQL Query to find when did the user last used his responsibilities
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.