Fusion does NOT expose database tables for user login data.
Fusion Cloud login timestamps are stored in the Identity Domain (IDCS/IAM) audit logs.
You should be able to run User Data Reports that can provide Successful logins and Unsuccessful logins.
Hi @RRB,
Welcome to the Oracle Analytics Community!
Please take a look into the following Oracle Documents which might be useful.
https://docs.oracle.com/en/cloud/saas/account-reconcile-cloud/adarc/admin_security_arcs_user_login_report.html
https://docs.oracle.com/en/cloud/saas/sales/fasqa/how-can-i-get-user-login-history-or-application-usage-from-oracle-fusion-applications.html
Hope this help.
Thank you.
Additionally, please take a look into the following post which will provide sql and tables related info.
How to see a user's login history? — Cloud Customer Connect