Find E-Business Suite users daily logins at the forms

Find E-Business Suite users daily logins at the forms


To find the users logins at the forms only use the following query

SELECT apps.fnd_user.user_name,apps.fnd_logins.START_TIME, apps.fnd_logins.END_TIME, apps.fnd_logins.LOGIN_TYPE FROM apps.fnd_logins, apps.fnd_user WHERE apps.fnd_logins.user_id = apps.fnd_user.user_id
AND TO_CHAR(start_time, 'DD/MM/YYYY') = TO_CHAR(SYSDATE, 'DD/MM/YYYY')
AND login_type= 'FORM'  --and apps.fnd_user.USER_NAME = 'SYSADMIN' ORDER BY start_time DESC;