'APP-FND-01346: Ensure database password for this ORACLE username matches new password' Error When Attempting to Register and Assign Password to New User in Forms
Last updated on OCTOBER 25, 2017
Applies to:Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
On : 12.1.3 version, Basic SysAdmin functions, maintenance
After cloning unable to register oracle user in apps release 12.1.
Running database 18.104.22.168.
STEPS TO REPRODUCE:
Created a user in the database.
Put in the password twice for the user in the register form in applications.
The following error appears in the register form:
"Unable to lock Oracle Applications Database account for user: <XXXX>"
APP-FND-01238: Cannot set value for field :ORACLE_USERID.ENCRYPTED_ORACLE_PASSWORD
Review your error messages (Help -> Diagnostics -> Display Database Error...) to see the cause of the error.
FRM-40654: Record has been updated by another user.
Basic Problem is when going through the registration process for creating user, after adding username and then typing in password twice, the error appears:
APP-FND-01346: Ensure database password for this ORACLE username matches new password.
Cause: You have registered a new password for this ORACLE username with Application Object Library. You must ensure that the actual database password matches this value. Until the registered password and the database password are identical you cannot use the ORACLE ID through Oracle Financials and you cannot register any ORACLE_ID. if you are changing the password of an APPS schema in Application Object Library release 10.7 or later, you must also change the password of the APPLSYS account and all other APPS schema accounts to match.
Action:Ensure you change the password in the database if you have not already done so. Connect to the ORACLE username to which you wish to change the password then issue the following SQL statement to change password.
SQL: GRANT CONNECT TO [ORACLE username] IDENTIFIED BY [Password]
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms