This query will give you history of user login with certain columns like login_user, first_login, last_login, accessed_product in Oracle Fusion ERP Cloud.
SELECT USER_NAME LOGIN_USER ,FIRST_CONNECT FIRST_LOGIN ,LAST_CONNECT LAST_LOGIN ,PRODUCT ACCESSED_PRODUCT FROM FND_SESSIONS WHERE USER_NAME =:BIND_USER