Script to reset User password in Oracle Apps

🔐 Script to Reset User Password in Oracle EBS from Backend

Oracle E-Business Suite (EBS) provides a built-in API that allows administrators to reset user passwords directly from the backend. This is especially useful when access to the front end is restricted or for bulk password resets.

---

📌 API Used: fnd_user_pkg.changepassword

This API accepts two input parameters:

• username – The EBS user login ID
• newpassword – The new password to assign

---

💡 Example: PL/SQL Block to Reset Password

Use the following anonymous PL/SQL block to reset a user's password:

SET SERVEROUTPUT ON;

DECLARE
    v_reset BOOLEAN;
BEGIN
    v_reset := fnd_user_pkg.changepassword(
                  username    => 'AKS123',
                  newpassword => 'Oracle123'
              );

    IF v_reset THEN
        DBMS_OUTPUT.PUT_LINE('✅ Password has been successfully reset.');
    ELSE
        DBMS_OUTPUT.PUT_LINE('❌ Password reset failed.');
    END IF;
END;
/ 
COMMIT;

Note: Replace 'AKS123' with the actual username and 'Oracle123' with a secure new password.

---

🔐 Best Practices

• Always run this script in a development or test instance first before using in production.
• Ensure your user has the necessary privileges to execute this API.
• Use complex passwords to meet security compliance.
• Keep audit logs of any manual password resets.

---

📎 Related Topics

• How to Lock/Unlock Users in Oracle EBS
• Create Users Programmatically in Oracle EBS
• Query to Check Last Login of EBS Users