Report to get list of users who are locked
Summary
I need to get a list of locked user accountsContent
I looked at the 'Reporting on Application Users and Roles' section the Oracle documentation, but none of those tells me whether an account is locked or not. We are using SSO and have had an issue where user accounts are locked (probably using the wrong login screen and trying too many times). I want to get a list of those that are locked but I can't see to find a way to report that.
The per_users table has active and suspended flag fields, but that's not the same as locked. Anyone had any luck with this?