Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Need clarification about last login date stored in the table ASE_USER_LOGIN_INFO — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need clarification about last login date stored in the table ASE_USER_LOGIN_INFO

Accepted answer
92
Views
7
Comments
edited Nov 1, 2018 5:02PM in Applications Security 7 comments

Summary

Need clarification about last login date stored in the table ASE_USER_LOGIN_INFO

Content

Hi,

We have come to know that the table ASE_USER_LOGIN_INFO is replacement for the fnd_sessions table (fnd_sessions gets purged after 7 days). Hence we were advised to run the process:" Import User Login History" which would store the fnd_sessions data into ASE_USER_LOGIN_INFO table. Now, my customer is in IST time zone and there work time is 9 AM to 6 PM IST. When I create a report using the table ASE_USER_LOGIN_INFO , the last_login_date fiels shows times between 3 AM and 4 AM which is highly impossible that the customer would have logged in at that time. This field might be storing server's timezone data .

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!