FNDCAPSS Oracle E-Business Suite Change Password

FNDCAPSS Oracle E-Business Suite Change Password
FNDCAPSS Oracle Apps Change Password
[applmgr@sys38 7305220]$ FNDCPASS
Usage: 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 database
mode is SYSTEM/USER/ORACLE
username is the username where you want to change its password
new_password is the new password in unencrypted format
example FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME

-- Sysadmin Password Change .( eg Sysadmin)

FNDCPASS apps/apps 0 Y system/manager USER sysadmin welcome123

-- Apps Password Change..(eg Apps user)

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

-- Oracle Apps User Password Change (eg.. GL,AR,AP)

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

-- ALLORACLE mode changes all oracle schema passwords (11i Need patch 4745998)

FNDCPASS apps/apps 0 Y system/manager ALLORACLE welcome123

The existing ORACLE mode can change only one oracle
schema password. ALLORACLE mode changes all oracle schema passwords at one time
using this command: FNDCPASS apps/apps 0 Y system/manager ALLORACLE welcome1
"All oracle schemas" does not include APPLSYS, APPS, external account, public
account. The effected schema name is based on read_only_flag='A'or'D' inside
fnd_oracle_userid table. We don't touch other accounts with a different
read_only_flag. 'A' means enabled, 'D' means disabled. If the actual oracle
account doesn't exist for a disabled account the "alter user" command to change
password will fail. This will be recorded in the log and is perfectly ok.



Note 363523.1 - Stand Alone Patch For FNDCPASS With 'ALLORACLE' Functionality
Note:398942.1 - FNDCPASS Utility New Feature ALLORACLE