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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How to get users last login date

edited Feb 1, 2020 3:06PM in Reporting and Analytics for HCM 16 comments

Content

Hi,

We have requirement to fetch all users last login date and time. May i know which table can help to get the info.

I tried FND_SESSIONS and ASE_USER_LOGIN_INFO but both these tables are not giving details of all users.

I need to fetch below columns mainly.

  • Person_Number
  • User_Name
  • Last_Login_Date/Time

Thanks - Avinash

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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