🔐 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.
