S_USER Table LAST_LOGIN_TS Column is Off a Few Hours (Doc ID 2278767.1)

Last updated on JUNE 20, 2017

Applies to:

Siebel Financial Services Call Center - Version 15.12 [IP2015] and later
Information in this document applies to any platform.

Goal

According to various other postings, the LAST_LOGIN_TS column on table S_USER is used to track when users last LOGGED OFF (as oppose to logged in per the name). However, it was noticed that the timestamp is off a few hours. UTC is enabled.

For instance, let's say the user is in EST timezone and logs out of the application at 1:00PM ET. We see LAST_UPD stored as 4:00PM GMT, which is correct as it is converted to 1:00PM ET. However, we see LAST_LOGIN_TS having a timestamp of 8:00PM, which does not seem to correlate to anything.

What causes the LAST_LOGIN_TS field to offset a few hours?

 

Solution

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