How to Change Apps password in oracle apps

Oracle provides a utility called FNDCPASS to change apps password,schema passwords,user passwords in Oracle Apps. There are a few points to remember->APPS and APPLSYS passwords are always same.Changing applsys password will automatically change the apps password. 

How to change apps password->

• Stop Application Services
• FNDCPASS apps/<apsppassword> 0 Y system/<systempassword> SYSTEM APPLSYS <newappspassword>
• eg->FNDCPASS apps/apps123 0 Y system/manager123 SYSTEM APPLSYS APPS321
• Start Application Services

Please note that in oracle Apps 11i, when changing apps password it is important to run autoconfig to propagate the change across the application or you will need change the apps password in following files manually if it exists.

1. $IAS_ORACLE_HOME\Apache\modplsql\cfg\wdbsvr.app file
2. $ORACLE_HOME/reports60/server/CGIcmd.dat

However, in oracle Apps R12.1, we do NOT need to run autoconfig after  changing apps password. Also, plz note in R12.1, apps password is NOT saved in any files on file system.

How to change an application schema password->

FNDCPASS apps/<appspassword> 0 Y system/<systempassword> ORACLE <SCHEMANAME> <newschamepassword>

eg->FNDCPASS apps/apps123 0 Y system/manager123 ORACLE GL GL123

How to change all application schema passwords at once. This feature is available from 11i.ATG_PF.H Rollup 3. Also there is a one off patch-4745998 for this feature->

FNDCPASS apps/<appspassword> 0 Y system/<systempassword> ALLORACLE <newschamepassword>

eg->FNDCPASS apps/apps123 0 Y system/manager123 ALLORACLE schemapass123

How to change an application user(front-end) password->

FNDCPASS apps/<appspassword> 0 Y system/<systempassword> USER <username> <newuserpassword>

eg->FNDCPASS apps/apps123 0 Y system/manager123 USER ANMGUPTA ANMGUPTA123.