Technology Stack - EBS (MOSC)

MOSC Banner

EBS custom Audit report

edited Aug 20, 2021 11:53AM in Technology Stack - EBS (MOSC) 4 commentsAnswered

Hi,

i am looking for a query to get details of all EBS users and all their responsibilities last logon date. i am using below queries to get last login date of responsibility. but it is not getting details of responsibility which was not logged in by users.please help me on this query to get details of all users and all their responsibilities. if he not logged in to resp it should show as null date. this is for Audit requirement.

select max(flr.start_time), flr.responsibility_id ,fu.user_name,

flt.responsibility_name

from fnd_logins fl, fnd_login_Responsibilities flr, fnd_user fu ,

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