Oracle Applications provides a command line utility, FNDCPASS, to change/reset Oracle Applications schema passwords.
This utility changes the password registered in Oracle Applications tables, changes the schema password in the database and can also change user passwords
Ensure that the entire Oracle Applications system has been shut down before changing any schema passwords.
All users should log out and the Applications system should be down before running this utility
Before changing any passwords, you should make a backup of the tables FND_USER and FND_ORACLE_USERID
To change the APPS and APPLSYS schema password:
ü FNDCPASS apps/**** 0 Y system/**** SYSTEM APPLSYS WELCOME
To change an Oracle Applications schema password (other than APPS/APPLSYS):
ü FNDCPASS apps/**** 0 Y system/**** ORACLE GL GL1
To change all ORACLE schema passwords:
ü FNDCPASS apps/**** 0 Y system/**** ALLORACLE WELCOME
To change an Oracle Applications user's password:
ü FNDCPASS apps/**** 0 Y system/**** USER SYSADMIN WELCOME
To Know the Previous changed information of FNDCPASS
ü Login to the apps user and type the following command
ü history |grep FNDCPASS
