How to Change application passwords in R12
Changing passwords frequently helps ensure database security, 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. Autoconfig needs to be run after changing 'APPLSYSPUB' or 'GUEST' user password 1. Changing Apps password Syntax: 1. FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME 2. FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1 3. FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME 4. FNDCPASS apps/apps 0 Y system/manager ALLORACLE Note: The SYSTEM token is used when changing the APPLSYS password. The ORACLE token is used when changing a SINGLE Applications schema password. The ALLORACLE token is used when changing ALL Applications schema passwords. The USE