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.

Nathan CCC

FYI Try this

Select Navigator, select Show More

In group My Enterprise select work area Setup and Maintenance

Select task Manage Administrator Profile Values

Profile Option Code = FND_TRACK_USER_ACTIVITY

update Profile Level = Site value from DISABLED to ENABLED

For more information see

https://docs.oracle.com/en/cloud/saas/sales/facaa/set-up-adoption-and-usage-tracking.html#s20074568

then get a list of sign in times (the max last connect time is stored in the parent user table

select all t.* from fnd_session_user_activity t

I think you can use scheduled process Import User Login History to move the data before it is purged after 7 days from FND_SESSION to table ASE_USER_LOGIN_INFO.

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

 

 

Sidney Mori

Hi Jason,

I can't to open the link , can you atach please?

Sidney

Nathan CCC

Sidney, The link is to an article in My Oracle Support. Only customers of oracle may read articles on My Oracle Support. It the link is broken just go to support.oracle.com then search for the article. As a customer of oracle when you purchased a licence you were given a support identifier. You can use this support identifier to register with My Oracle Support so that you can read these articles that are posted in answers on these community forums. but yes it looks like this article is no longer available 2043622.1.