Human Capital Management - EBS (MOSC)

MOSC Banner

EBS login responsibilities and login information

Hi team,


I have request from our audit team to provide them lookback (sign on dates history) for certain number of users. I have tried with these two queries below but non of them gave me results:


 SELECT DISTINCT fu.USER_NAME,

         fl.LOGIN_NAME,

         fl.start_time,

         fl.END_TIME,

         fl.LOGIN_TYPE,

         ftl.RESPONSIBILITY_NAME

  FROM FND_LOGINS         fl,

     fnd_user          fu,

     FND_LOGIN_RESPONSIBILITIES fr,

     fnd_responsibility_tl   ftl,

     fnd_responsibility     frr,

     fnd_user_resp_groups_direct furg

  WHERE   fu.USER_ID = fl.USER_ID

     and fl.login_id = fr.login_id

     AND fr.RESPONSIBILITY_ID = ftl.RESPONSIBILITY_ID

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