How to View and Unlock Locked Users in Oracle Fusion

How to View and Unlock Locked Users in Oracle Fusion

In Oracle Fusion Applications, user accounts can become locked due to multiple failed login attempts, inactivity, or administrative actions. As a security measure, Oracle Fusion automatically disables or locks accounts based on the configured authentication policies.

In this post, we will see how to identify locked users and unlock them using the Oracle Fusion UI and SQL queries.

🔍 Reasons Why Users Get Locked in Oracle Fusion

• Multiple incorrect login attempts
• Inactivity for a long period
• Expired password without reset
• Manual locking by admin or automated ESS jobs

🧭 Method 1: View and Unlock Users Using Fusion UI

Navigation: Tools → Security Console → Users

🔹 Steps to Identify Locked Users:

1. Open the Security Console
2. Use the Advanced Search
3. Add filter: Account Status = Locked
4. Click Search

🔓 To Unlock a User:

1. Click on the locked user's name
2. Click on Actions > Unlock User Account
3. Confirm and save

You must have IT Security Manager or User Administrator role to perform this action.

🧾 Method 2: View Locked Users via SQL Query

SELECT user_name,
       email_address,
       account_locked,
       last_logon_date,
       user_guid,
       start_date,
       end_date
FROM fnd_user
WHERE account_locked = 'Y'
ORDER BY last_logon_date DESC;

🔓 Method 3: Unlock User via SQL Update (For On-Prem or Non-SaaS Only)

⚠️ Warning: This is for non-SaaS environments only.

UPDATE fnd_user
SET account_locked = 'N'
WHERE user_name = 'USERNAME';

⚠️ Important Notes

• In Oracle SaaS (Cloud), backend updates are not allowed. Always use the Security Console.
• Make sure your actions comply with company IT policies.
• Frequent lockouts? Review password policy under Security Console > Password Policies.

✅ Conclusion

Oracle Fusion provides secure ways to manage user accounts. Use the Security Console to unlock users in SaaS.