Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Audit Related: Last Logon Session

Accepted answer
285
Views
4
Comments
Jason Schwartz
Jason Schwartz Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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.

Tagged:

Best Answer

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Apr 23, 2024 8:14AM Answer ✓

    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.

Answers

  • Jason Schwartz
    Jason Schwartz Rank 1 - Community Starter

    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
    Sidney Mori Rank 2 - Community Beginner

    Hi Jason,

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

    Sidney

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Apr 23, 2024 8:12AM

    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.