Find E-Business Suite users daily logins at the forms
                                                 Last update (2008-06-09 21:52:44)
                                                                                                                   Date added (2008-02-18 12:35:26)

Summary
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;
Other links
Unsuccessful logins
Reviews
Filters
Search