How to change APPS password in EBS 11i

***************How to change APPS Password in EBS 11i******************

Here are the steps to change apps password in 11i EBS

1) Shut down the application on all nodes
2) Take the backup below files on all application nodes.

$IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
$ORACLE_HOME/reports60/server/CGIcmd.dat  (8.0.6 Oracle_home)
$FND_TOP/resource/wfmail.cfg

3) Backup below tables
=====================

SQL> create table FND_USER_BK_<YYYYMMSS> as select * from FND_USER;
SQL> create table FND_ORACLE_USERID_BK_<YYYYMMSS> as select * from FND_ORACLE_USERID;

4) Change apps password using below command.

FNDCPASS apps/<appspwd> 0 Y system/<pwd> SYSTEM APPLSYS <new password>

 **Changing APPLSYS user password will automatically changes APPS user password.

5) Change APPS password in the following files.

$IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
$ORACLE_HOME/reports60/server/CGIcmd.dat  (8.0.6 Oracle_home)
$FND_TOP/resource/wfmail.cfg

6) Start Application on all the nodes.

7 ) Validate services.

8) Recreate DB links if any needed.

9) Check any cron job that have apps password hardcoded.

Thanks.

Sreeharsha