FNDCPASS Utility

FNDCPASS is a Oracle provided FND Utility to change the passwords in Oracle Applications. FNDCPASS submits a concurrent request for completing the FNDCPASS request. Thus creates a log and output file in the location from where FNDCPASS is run. Check the log file for any errors. You can refer MOS Doc ID: 437260.1 for details. We can change the below passwords using FNDCPASS:

1. 1.APPLSYS / APPS
2. 2.Oracle EBS Product Schema Passwords e.g. ap, ar, pay etc
3. 3.Front End User Passwords e.g. SYSADMIN etc

Changing User Password:

To find the syntax, just type FNDCPASS which gives the syntax. The below are the sample examples:

FNDCPASS apps/apps 0 Y system/manager USER   VISION  WELCOME

(Here WELCOME denotes new password of the Applications User VISION)

Changing Product Schema Password:

The following is the usage of FNDCPASS to change Product Schema Password:

FNDCPASS apps/apps 0 Y system/manager ORACLE   GL  GL1

(Here GL1 denotes new password of Product Schema GL)

Changing APPS Password:

The following is the usage of FNDCPASS to change APPS Password:

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME

(Here WELCOME denotes new APPS password)

NOTE:

In 11i, After changing the APPS Password by using FNDCPASS, the password needs to be changed manually in the following files.

1. $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
2. $ORACLE_HOME/report60/server/CGIcmd.dat

In R12, we need not edit these files as they are not used anymore in R12 but we need to run Autconfig after changing any passwords using FNDCPASS. Make sure that the customizations have preserved before running Autoconfig.

Changing all Product Schema Passwords at once:

FNDCPASS apps/apps 0 Y system/manager ALLORACLE   WELCOME

(This changes the password of all Product Schemas to WELCOME)

Note:

Y denotes the method of invocation i.e. submitting a concurrent request from Command Line
0 denotes the Request ID as it has been submitted from OS Level

AFPASSWD:

AFPASSWD is a new utility which is available from 12.1.2 onwards. This utility can be run from both DB Tier as well as the application tier. When the utility is runt o change any passwords, it prompts for the password couple of times to confirm the password.

Practicals of AFPASSWD will be provided soon by one of the bloggers.