What table houses data related to user login times?

RRB

RVohra

Fusion does NOT expose database tables for user login data.

Fusion Cloud login timestamps are stored in the Identity Domain (IDCS/IAM) audit logs.

RVohra

You should be able to run User Data Reports that can provide Successful logins and Unsuccessful logins.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27652/what-table-houses-data-related-to-user-login-times

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.

Bhaskar Konar

Hi @RRB,

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

Hope this help.

Thank you.