Change Oracle Apps Database Users,Product Schema and End User Password

Note:

• Recommend taking backup of the tables FND_USER and FND_ORACLE_USERID before changing the passwords
• I would you suggest you to first try changing the passwords using FNDCPASS on your test Apps Instances, once you are done with this without any errors or issues then you can move this to production
• Utility, FNDCPASS, cannot be used for changing the database SYSTEM and SYS users.
  Only users that are registered in FND meta data tables need to be changed using FNDCPASS.
• Normally, the APPS database user password and APPLSYS password need to be the same.
• When changing the APPLSYS password using FNDCPASS, the APPS password is also changed.

FNDCPASS changes:

• Oracle Applications Database System Users (APPS, APPLSYS)
• Oracle Applications Product Schema Passwords (GL, AR, AP, etc,)
• Oracle Applications End User Account Passwords (SYSADMIN, OPERATIONS etc)

Syntax of FNDCPASS command:

FNDCPASS logon 0 Y system/password mode username new_password

Where logon is username/password[@connect]System/password is password of the system account of that databaseMode is SYSTEM/USER/ORACLEUsername is the username where you want to change its passwordnew_password is the new password in unencrypted format

Example:

Chang Application Database System User(APPS,APPLSYS) password.

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

Note:
When changing the APPLSYS password using FNDCPASS, the APPS password is also changed.
must Restart Concurrent Manager.

Change Application Produce Scheme(FA,GL.AP,AR etc) password.

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

Change Application End User Account (SYSADMIN,ANKIT,KAPIL,ANUP etc) password

$ FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN WELCOME

New Feature:

The FNDCPASS has a new mode, "ALLORACLE", in which all Oracle Application schema passwords can be changed in one call. Apply the patch (Patch No# 4745998) to have this option, if not available currently with your Apps.

Syntax:

FNDCPASS 0 Y ALLORACLE

Example:

$ FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME