Wednesday, February 15, 2012

Responsibility log in information or Forms Access information


select frv.responsibility_name,flr.start_time, flr.end_time, fu.user_name  from APPLSYS.FND_LOGIN_RESPONSIBILITIES flr,
FND_RESPONSIBILITY_VL frv, FND_LOGINS fl, fnd_user fu
where flr.RESPONSIBILITY_ID = frv.RESPONSIBILITY_ID
and frv.responsibility_name = 'Application Developer'
and fl.login_id = flr.login_id
and fl.user_id = fu.user_id
order by flr.start_time ,fu.user_name;


select frv.responsibility_name,flr.start_time, flr.end_time, fu.user_name, ff.user_form_name  from FND_LOGIN_RESPONSIBILITIES flr,
FND_RESPONSIBILITY_VL frv, FND_LOGINS fl, fnd_user fu, FND_LOGIN_RESP_FORMS flrf, FND_FORM_VL ff
where flr.RESPONSIBILITY_ID = frv.RESPONSIBILITY_ID
and flrf.login_id = flr.login_id
and flrf.LOGIN_RESP_ID = flr.LOGIN_RESP_ID
and frv.responsibility_name = :P_RESPONSIBILITY_NAME --'Application Developer'
and flr.start_time > sysdate -5
and fl.login_id = flr.login_id
and fl.user_id = fu.user_id
and ff.form_id = flrf.form_id
order by flr.start_time desc,fu.user_name;


These all table will be purged by  concurrent program "Purge Signon Audit data"

fnd_login_resp_forms
FND_LOGIN_RESPONSIBILITIES
FND_UNSUCCESSFUL_LOGINS
FND_APPL_SESSIONS
FND_LOGINS

No comments:

Post a Comment