Need clarification about last login date stored in the table ASE_USER_LOGIN_INFO
SummaryNeed clarification about last login date stored in the table ASE_USER_LOGIN_INFO
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 .