Core Workflow - EBS (MOSC)

MOSC Banner

Fixing APPS/APPLSYS passwords after manually changing them in DB

Oracle Database 19c

Oracle E-Business Suite 12.2.14

TEST ENVIRONMENT

Hello community,

as a new database admin, I messed up with password management for EBS related users. So I run below commands on database node:

alter user APPS identified by <password>;
alter user APPLSYS identified by <same_password>;

During run of adadmin (trying to install new language to database) I noticed that APPS password is not going through, despite making absolute sure that it's correct.

I learned that I most likely desynchronized/corrupted passowrd hashes in FND_USERS table, and now I'm looking for any way not requiring backup (junior DBA) to make those passwords work again.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center