Changing Apps password using FNDCPASS

Oracle provides a utility called FNDCPASS to change apps password,schema passwords,user passwords.There are a few points to remember->APPS and APPLSYS passwords are always same.Changing applsys password will automatically change the apps password
To change apps password->
FNDCPASS apps/ 0 Y system/ SYSTEM APPLSYS
eg->FNDCPASS apps/apps123 0 Y system/manager123 SYSTEM APPLSYS APPS321
To change an application schema password->
FNDCPASS apps/ 0 Y system/ ORACLE
eg->FNDCPASS apps/apps123 0 Y system/manager123 ORACLE GL GL123
To change all application schema passwords at once. This feature is available from 11i.ATG_PF.H Rollup 3. Also there is a one off patch-4745998 for this feature->
FNDCPASS apps/ 0 Y system/ ALLORACLE
eg->FNDCPASS apps/apps123 0 Y system/manager123 ALLORACLE schemapass123
To change an application user(front-end) password->
FNDCPASS apps/ 0 Y system/ USER
eg->FNDCPASS apps/apps123 0 Y system/manager123 USER ANMGUPTA ANMGUPTA123.
Please note that when changing apps password it is important to run autoconfig to propagate the change across the application or you will need change the apps password in following files manually if it exists.
1. $IAS_ORACLE_HOME\Apache\modplsql\cfg\wdbsvr.app file
2. $FND_TOP/resource/wfmail.cfg
3. $COMMON_TOP/admin/scripts//adcmctl.ch
4. $OA_HTML/bin/appsweb.cfg
5. $AD_TOP/admin/template/CGIcmd.dat


Change passowrd

begin
if fnd_user_pkg.changepassword('RAJSHEKHAR','welcome@123') then
null;

end if;
end;


enableuser

begin
exec fnd_user_pkg.enableuser('RAJSHEKHAR',sysdate,sysdate+1000) then
commit;

end;

         Everyone knows Apps Password changing policy or process. But after changing the password, We have to   run autoconfig   in Application Level. Sometimes, After autoconfig run, Custom level setting will be lose.  So, Better We can choose manually way the apps password.

 Two Method for Changing Apps Password using FNDCPSS

A.  Autoconfig method after password change

B. Manually method after password change.

A.  Autocong method after password change:-

1. Shutdown all the application nodes.

2. Issue the commands at the Unix command line similar to the following:

To change the APPS and APPLSYS passwords:

$FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS apps123

3. Check the apps password is working using "sqlplus apps/apps123".

4. Run the autoconfig  in application nodes.

5. Start the application services.

6. Check Application Health checkup.

B. Manually method after password change.

1. Shutdown all the application nodes.

2. Shutdown the concurrent node.

3. Backup the below given 3 files before changing the apps password:

i)  $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app

ii) 8.0.6 Oracle_home : $ORACLE_HOME/reports60/server/CGIcmd.dat

iii) $FND_TOP/resource/wfmail.cfg

4. Issue the commands at the Unix command line similar to the following:

   To change the APPS and APPLSYS passwords:

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS

$FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS apps123

NOTE 1: Changing the APPLSYS password automatically changes the APPS password

to match as these two must always agree.

NOTE 2: VERY IMPORTANT!!

When changing the password for APPS it is important to manually change the APPS

password in the following files as well as necessary:

5. Change the apps password in the following files:

i). $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app

(Otherwise users will not be able to login to the Personal Home Page or Self-service web apps.)

ii). 8.0.6 Oracle_home : $ORACLE_HOME/reports60/server/CGIcmd.dat

iii). Workflow Notification Mailer - $FND_TOP/resource/wfmail.cfg

6. Start the concurrrent manager script.

7. Start all the application nodes.

8. Application Health checkup.

8. Submit a concurrent request and check that request completes successfully.