What Happens When You Use ALTER USER Command To Change EBS User Passwords
The Problem with ALTER USER When you change a EBS applicatation user's password directly at the database level using the ALTER USER command: The new password is updated only in the database. The password remains unchanged in the EBS application's FND tables . Why This Matters The FND tables store encrypted versions of user passwords, and they must be synchronized with the database. If the passwords between the FND tables and the database are out of sync: The EBS application won't recognize the new password. Login failures occur. Application functionality is disrupted. The Correct Approach To avoid these issues, passwords should always be changed through: The EBS application itself, or The FNDCPASS utility . Using these methods ensures that: The database password is updated. The corresponding encrypted password in the FND tables is also updated. Related Posts: FNDCPASS Utlity in R12.2 How to Grant Privileges in Oracle EBS R12.2 Using AD_ZD.GRANT_PRIVS