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

Can we fetch login data of all users for a year with Login Date and not LAST LOGIN DATE? All logins

Received Response

We have a audit requirement to present them with data of all users and all their logins in the past 1 year.

For eg if a user XYZ has logged in 10 times into the instance we require 10 rows of the user saying XYZ(user name), role name and login date for time frame 1st Jul 2022 to 25-JUL-2023(today).

Possibilites tried: FND_SESSIONS which stores data upto 7 days and ASE_USER_LOGIN_INFO which is just giving the LAST LOGIN DATE and not the login dates for a user for a particular time period.

We need this data to comply with Audit Norms/Regulations.

Howdy, Stranger!

Log In

To view full details, sign in.


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