Oracle Applications HOWTO: change apps password

Go to Michael Dvorkin's user page

Prerequisites
E-Business Suite 11.5.9, 11.5.10

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

Go to Michael Dvorkin's user page