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 Using FNDCPASS utility.

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

Now run Autoconfig.

5. To Change apps password in configuration files Manually :

$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