EBS R12: How to Change Applications Passwords using Applications Schema Password Change Utility (FNDCPASS)

A).To change the APPS and APPLSYS schema password:

Use the following command to change passwords for schema that are used by shared components of Oracle Applications. 

FNDCPASS <logon> 0 Y <system/password> SYSTEM <username> <new_password>

FNDCPASS uses the following arguments when changing the APPLSYS password. When specifying the SYSTEM token, FNDCPASS expects the next arguments to be the APPLSYS username and the new password. 

• logon                        The Oracle username/password.
• system/password    The username and password for the SYSTEM DBA account.
• username                 The APPLSYS username. For example, 'applsys'.
• new_password         The new password.

B). To change an Oracle Applications schema password (other than APPS/APPLSYS):

 Use this command to change the password of a schema provided by an individual product in Oracle Applications. 

FNDCPASS <logon> 0 Y <system/password> ORACLE <username> <new_password>

Use the above command with the following arguments. When specifying the ORACLE token, FNDCPASS expects the next arguments to be an ORACLE username and the new password.

• logon                         The Oracle username/password.
• system/password     The username and password for the SYSTEM DBA account.
• username                 The Oracle username. For example, 'GL'.
• new_password         The new password.

For example, the following command changes the GL user password to 'GL1'.

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

C). To change all ORACLE schema passwords:

Use this command to change the passwords of all schemas provided by Oracle Applications products. 

FNDCPASS <logon> 0 Y <system/password> ALLORACLE <new_password>

Use the above command with the following arguments. When specifying the ALLORACLE token, FNDCPASS expects the next argument to be the new password.

• logon                          The Oracle username/password.
• system/password      The username and password for the SYSTEM DBA account.
• new_password          The new password.

For example, the following command changes all ORACLE schema passwords to "WELCOME":

FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME

For additional information on the use of ALLORACLE, please reference NOTE 189367.1 - Best Practices for Securing the E-Business Suite

D). To change an Oracle Applications user's password:

Use this command to change an individual Oracle Applications user's password.

FNDCPASS <logon> 0 Y <system/password> USER <username> <new_password>

Use the above command with the following arguments. When specifying the USER token, FNDCPASS expects the next arguments to be an Oracle Applications username and the new password.

• logon                          The Oracle username/password.
• system/password      The username and password for the System DBA account.
• username                   The Oracle Applications username. For example, 'VISION'.
• new_password          The new password.

For example, if you were changing the password for the user VISION to 'WELCOME', you would use the following command:

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

NOTE: Run autoconfig after you are done with changing the passwords.

Thanks,
Kaziul Islam Bulbul,
Dhaka Bangladesh