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

Report to get list of users who are locked

edited Sep 26, 2018 9:20PM in Reporting and Analytics for HCM 17 comments

Summary

I need to get a list of locked user accounts

Content

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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