FND User Login History

특정화면

특정기간

log 조회!

 

select (x.start_time) start_time
      ,(x.end_time) end_time
      ,x.user_name
      ,frv.responsibility_name responsibility
      ,x.form
      ,x.icx_function
      ,x.user_id
from   (select nvl(flrf.start_time, nvl(flr.start_time, fl.start_time)) start_time
              ,nvl(flrf.end_time, nvl(flr.end_time, fl.end_time)) end_time
              ,fu.user_name user_name
              ,ffv.user_form_name form
              ,fffv.user_function_name icx_function
              ,fl.login_id
              ,nvl(flr.resp_appl_id, ixs.responsibility_application_id) resp_appl_id
              ,nvl(flr.responsibility_id, ixs.responsibility_id) responsibility_id
              ,ffv.form_id
              ,fu.user_id
        from   fnd_logins                 fl
              ,fnd_login_responsibilities flr
              ,fnd_login_resp_forms       flrf
              ,fnd_form_vl                ffv
              ,icx_sessions               ixs
              ,fnd_form_functions_vl      fffv
              ,fnd_user                   fu
        where  nvl(flrf.start_time, nvl(flr.start_time, fl.start_time)) >= date     '2023-01-01'
        and    1 = 1
        and    fl.login_type = 'FORM'
        and    fl.login_id = flr.login_id(+)
        and    flr.login_id = flrf.login_id(+)
        and    flr.login_resp_id = flrf.login_resp_id(+)
        and    flrf.form_appl_id = ffv.application_id(+)
        and    flrf.form_id = ffv.form_id(+)
        and    fl.login_id = ixs.login_id(+)
        and    ixs.function_id = fffv.function_id(+)
        and    fl.user_id = fu.user_id        
        ) x
      ,fnd_responsibility_vl frv
where  2 = 2
and    x.resp_appl_id = frv.application_id(+)
and    x.responsibility_id = frv.responsibility_id(+)
and    x.form_id = 64667
order  by x.login_id   desc
 ,x.start_time desc;

 

 

 

 

 

 

 

https://oraclereporting.com/FND%20User%20Login%20History/

FND User Login History