Changing Application user password and Changing User product schema password

Chaning Application user password
====================================
FNDCPASS apps/apps 0 Y system/manager USER   VISION  WELCOME
is for changing the application level passwords like dbateam,vision,sysadmin and etc used for logging into application.

Following activities will take place

(1) update VISION’s password in FND_USER table. The new password is re-encrypted with the current applsys password.

If VISION does not exist, message for invalid application user is written in the log file.





Chaning User product schema password
===================================
FNDCPASS apps/apps 0 Y system/manager ORACLE GL  GL1
is for changing password for any other product schema like AP,AR,PO,MSC,GL and etc.

Following activities will take place

(1) update GL’s password in FND_ORACLE_USERID table.
The new password is re-encrypted with the current applsys password.

If GL does not exists, step (2) below does not happen. Message for invalid oracle user is written in the log file.
(2) alter user to change GL’s password.

How to get ALLORACLE mode in FNDCPASS ?

Apply Oracle Apps patch 4745998.

What files to change after changing Apps Password ?

1. $IAS_ORACLE_HOME\Apache\modplsql\cfg\wdbsvr.app 

2. $FND_TOP/resource/wfmail.cfg

3.$ORACLE_HOME/reports60/server/CGIcmd.dat

Please click on the below link to see how to change APPLSYS password in Oracle Application 11i/R12

FNDCPASS in– Oracle Applications 11i & R12