Audit Related: Last Logon Session

Jason Schwartz

Summary

Last LogOn Session: Looking for a audit related report that shows last time accessing Oracle

Content

I am able to query HCM related tables (such as per_users) to find data necessary for audit - which provides information when a new user was created, termed and if the user is Enabled/Disabled - along with roles.

However, I am trying to find when was the last time a user logged into Oracle Fusion Cloud.  I have limited experience querying for this particular data and Audit Reports icon available.  But this appears to be associated with Events of inserting/deleting an object.

I believed that the information was in FND_Sessions table (see below), but this seems to hold the data for approximately 1 week.

 

Select user_name, max(last_connect) from FND_Sessions where user_name like '%@xxxxx.com' group by user_name

 

Any thoughts?  (It's Audit Season!)

Thank you.

Jason Schwartz

For anyone having a similar issue locating the last login session of users, I located an excellent Doc which truly helps explain and resolve my issue.

The Doc ID # is 2043622.1

 

Oracle Support Document 2043622.1 (How to Create User Login Audit Report) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2043622.1

 

Regards,

Jason