Check below SQL from backend
SELECT * FROM FND_USER_V WHERE USER_NAME = < input User_name >
I just checked this view is not available. Then I re verify my version of Database. it's 126.96.36.199.0 and what I mentioned mistakenly above is 188.8.131.52
The view that I found is FND_USER_VIEW instead of FND_USER_V.
it's just because of version?
Try with table : FND_USER
Ok. Yes I have this table. But I don't have required columns.
If Account is locked, Status, How many times with wrong password etc.
From this table you can get not all but so many information.
3 - If Password Needed for login?
4 - Does password expire
5 - If user is allowed to change the password?
6 - If user is forced to change password in next login.
7 - Last password change date
9 - Last un-successful Logon Attempt.
10 - how many times are user has logged in.
11- How many un successful logon attempts happens since last clearing of account.
12- timezone For this user.
Still I couldn't find these all points.