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

User Last Login Detail

edited Apr 9, 2020 1:22PM in Applications Security 3 comments

Summary

User Login Detail.

Content

Hi,

I need to fetch user last login details, FND_SESSION table hold max last 7 days records, is there any way we can fetch older history. Like who has not been login since last 3 month or so?

There is another table ASE_USER_LOGIN_INFO which gets populated from FND_SESSION table via some ESS. Need to know the ESS and its functionality. HCM Table and View site has v limited info on this table.

br

Azfar.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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