Oracle Applications HOWTO: change apps password

Steps to change apps password

1. Backup entire system

2. Stop concurrent manager

  cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
 adcmctl.sh stop apps/

3. Backup FND_ORACLE_USERID table

  sqlplus apps/
 drop table FND_ORACLE_USERID_BAK;
 create table FND_ORACLE_USERID_BAK as select * from FND_ORACLE_USERID;
 exit;

4. Change apps password

  $FND_TOP/bin/FNDCPASS apps/ 0 Y system/ SYSTEM APPLSYS 

5. Change apps password in configuration files

  $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
 $IAS_ORACLE_HOME/listener/cfg/wdbsvr.app
 $ORACLE_HOME/listener/cfg/wdbsvr.app
 $FND_TOP/resource/wfmail.cfg
 $OA_HTML/bin/appsweb.cfg
 $AD_TOP/admin/template/CGIcmd.dat

Known Issues

1. Symptom : Can not login to Oracle Applications

  Cause   : Invalid apps password in $IAS_HOME/Apache/modplsql/cfg/wdbsvr.app
 Solution: Change apps password in $IAS_HOME/Apache/modplsql/cfg/wdbsvr.app