Using the FNDCPASS Utility

How to Change Applications R12 Passwords using Applications Schema Password 

Change Utility

Since changing passwords frequently helps ensure database security, Oracle 

Applications provides a command line utility, FNDCPASS, to change/reset Oracle 

Applications schema passwords. This utility changes the password registered in

 Oracle Applications tables, changes the schema password in the database and 

can also change user passwords.
Note: You cannot change a schema name, such as APPLSYS or GL, after a product 

is installed, with FNDCPASS.
Ensure that the entire Oracle Applications system has been shut down before 

changing any schema passwords.
All users should log out and the Applications system should be down before 

running this utility.
If Oracle Applications user passwords are being changed then the relevant 

users should not be logged in.
Before changing any passwords, you should make a backup of the tables 

FND_USER and FND_ORACLE_USERID.

Using the FNDCPASS Utility:
FNDCPASS / 0 Y \

/
Please set the depending on your needs:

Note:
The SYSTEM token is used when changing the APPLSYS password.
The ORACLE token is used when changing a SINGLE Applications schema password.
The ALLORACLE token is used when changing ALL Applications schema passwords.
The USER token is used when changing an Applications USER password.

Note: Passwords for APPLSYS and the APPS schemas -- including the MRC schema 

-- must be the same. If you change the password for one, FNDCPASS 

automatically changes the others. When changing APPS (or APPLSYS)

 and APPLSYSPUB passwords, do not restart the system until the entire 

password change process has been completed.


Verify the new password.

If you changed the password for APPS (and APPLSYS), restart all concurrent 

managers, then log on to Oracle Applications to test the new password.


Examples:

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 0 Y SYSTEM

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.

This command does the following:

   1. Validates APPLSYS.
   2. Re-registers password in Oracle Applications.
   3. Changes the APPLSYS and all APPS passwords (for multi-APPS schema 

installations) to the same password.
      Because everything with a Privilege Level [set to any of ('E', 'U', 'D')] 

in the FND_ORACLE_USERID table must always have the same password, FNDCPASS updates

 these passwords as well as APPLSYS's password.
      For example, the APPS password will be updated when the APPLSYS password 

is changed.
   4. ALTER USER is executed to change the ORACLE password for the above ORACLE 

users.

For instance, the following command changes the APPLSYS password to 'WELCOME'.

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


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 0 Y ORACLE

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 0 Y ALLORACLE

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


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

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

FNDCPASS 0 Y USER

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


Run Autoconfig.


Show Related Information Related
Products

    * Oracle E-Business Suite > Applications Technology > Application Object 

Library > Oracle Application Object Library

Keywords
FND_USER; FNDCPASS; PASSWORD; LOGON; R12; ALTER USER; AUTOCONFIG; CHANGE 

PASSWORD