Use Audit Log to Track User Login vs. Reporting of Last_Login_Time In Ps_User_Prop Table (Doc ID 1230916.1)

Last updated on MAY 02, 2017

Applies to:

Primavera Portfolio Management - Version 7.5 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Sep-2013***


Symptoms

If reporting against PPM to gather PPM login information, it may appear that the LAST_LOGIN_TIME in PS_USER_PROP has incorrect data. For example, when looking at data in HW_SESSION_HISTORY, it's expected that you would see current login sessions from today. However, in some cases, the LAST_LOGIN_TIME can show data from the past (which doesn't match with what is shown in HW_SESSION_HISTORY.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms