FNDCPASS and AFPASSWD

Last updated on March 3rd, 2019 at 06:06 pm

FNDCPASS is an important utility in EBS application and it is located in $FND_TOP/bin.  It is used to change password for apps schema, oracle EBS schema password and application user password change.

$FNDCPASS

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS

FNDCPASS apps/apps 0 Y system/manager ORACLE

FNDCPASS apps/apps 0 Y system/manager USER

When you execute FNDCPASS, it create an log file and one output file. These log and out files are created in the same directory from which FNDCPASS is executed. If the command complete successful ,log file will be completion message else it will contain the error message for the password change

Change APPS/APPLSYS Passwords

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS <new pass>
Note: AutoConfig must be run and all application tier services restarted after changing the APPS password.

Change Oracle EBS Schema Password (e.g., GL, FA, AR, etc.)

Here is the command to change password for GL schema

FNDCPASS apps/apps 0 Y system/manager ORACLE GL <new pass>

Change All Oracle EBS Schema Passwords (e.g., GL , FA, AR, etc.) in one command using ALLORACLE 

FNDCPASS apps/apps 0 Y system/manager ALLORACLE <new pass>

Change Oracle EBS Application User Password

General syntax is

FNDCPASS apps/apps 0 Y system/manager USER <username> <new pass>

Here is example for change TEST application user

FNDCPASS apps/apps 0 Y system/manager USER TEST <new pass>

Lock All Oracle EBS Schema Accounts (R12.1+)

AFPASSWD apps/apps@ -L TRUE

Leave a Reply