Signon Password Failure Limit

Set the Following Profile option if one wants to restrict user via No of Attempts while Logging into the System

Profile Option: “Signon Password Failure Limit” à Set No of Attempts

Question: How to activate the user after user account gets “Locked”

Follow the Metalink Note ID to Purge Unsuccessful Attempts from Database as said Below

     1) How to Purge Data from the FND_UNSUCCESSFUL_LOGINS Table? (Doc ID 388088.1)

          Concurrent Program: Purge Signon Audit Data

         Following Tables are Purged once the above Request is Run

         Concurrent Processing - List of Tables Accessed by the Purge Signon Audit Data Concurrent Program (Doc ID                   1016344.102)

              FND_LOGIN_RESP_FORMS

              FND_LOGIN_RESPONSIBILITIES

              FND_LOGINS

              FND_UNSUCCESSFUL_LOGINS

     2) Reset User Password and the account will turn "Active"