FNDCPASS Examples
What is FNDCPASS?
To change the password in Oracle Applications 11i & R12, The FND binary which will help us is doing these things is FNDCPASS. This is present in $FND_TOP/bin directory.
Below is the usage for FNDCPASS.You can just type FNDCPASS and press enter , it will give you these details.
$ 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.
Few Imp Points to Note:
a.The tables that FNDCPASS uses are FND_USER and FND_ORACLE_USERID.
All the application passwords and schema passwords are stored in these two tables along with DBA_USERS.so always backup the above 3 tables before using FNDCPASS.
b. Ensure that the entire Oracle Applications system has been shut down before changing any schema passwords.
c.Never update apps, applsys and other product schema password directly from database using the alter command.Database core schema's like sys,system passwords can be changed using ALTER command in database.Applsyspub is a public database schema used in Oracle Applications , This account password can be changed using FNDCPASS.
d.In Oracle Apps 11i (Not needed in R12( when changing the password for APPS it is important to manually change the APPS password in the following:
$IAS_ORACLE_HOME\Apache\modplsql\cfg\wdbsvr.app file
$FND_TOP/resource/wfmail.cfg
$AD_TOP/admin/template/CGIcmd.dat
e.FND_USER and FND_ORACLE_USERID. The FND_USER table stores application user account passwords and the FND_ORACLE_USERID table stores internal Oracle Applications database account passwords.
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
0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
0 is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form.
'Y' indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.
1)FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
The above syntax is used for changing the password for apps and applsys.Apps and applsys are database schemas of Oracle Applications.Alter user command should never be used to change the apps & applsys accounts.Oracle recommends using FNDCPASS only to change apps and applsys password.Please note that above command will change the password for both apps and applsys.
When we try to change the password, internally the following will take place.
a.Validations of current applsys & system password
b.Re-encrypt all password in FND_USER & FND_ORACLE_USERID
c.Update apps & applsys password in FND_ORACLE_USERID table.
d.Update DBA_USERS table as well.
2)FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
The above syntax is used for changing password for any other product schema like AP,AR,GL etc.
When we try to change the password, internally the following will take place.
a.Validations of current applsys & system password
b.update GL new password in FND_ORACLE_USERID table
c.Update DBA_USERS table as well.
3)FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
The above syntax is used for changing the application level passwords like sysadmin etc. front end applications user password.
When we try to change the password, internally the following will take place.
a.Validations of current applsys & system password
b.Update VISION NEW password in FND_USER table.
What is FNDCPASS?
To change the password in Oracle Applications 11i & R12, The FND binary which will help us is doing these things is FNDCPASS. This is present in $FND_TOP/bin directory.
Below is the usage for FNDCPASS.You can just type FNDCPASS and press enter , it will give you these details.
$ 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.
Few Imp Points to Note:
a.The tables that FNDCPASS uses are FND_USER and FND_ORACLE_USERID.
All the application passwords and schema passwords are stored in these two tables along with DBA_USERS.so always backup the above 3 tables before using FNDCPASS.
b. Ensure that the entire Oracle Applications system has been shut down before changing any schema passwords.
c.Never update apps, applsys and other product schema password directly from database using the alter command.Database core schema's like sys,system passwords can be changed using ALTER command in database.Applsyspub is a public database schema used in Oracle Applications , This account password can be changed using FNDCPASS.
d.In Oracle Apps 11i (Not needed in R12( when changing the password for APPS it is important to manually change the APPS password in the following:
$IAS_ORACLE_HOME\Apache\modplsql\cfg\wdbsvr.app file
$FND_TOP/resource/wfmail.cfg
$AD_TOP/admin/template/CGIcmd.dat
e.FND_USER and FND_ORACLE_USERID. The FND_USER table stores application user account passwords and the FND_ORACLE_USERID table stores internal Oracle Applications database account passwords.
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
0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
0 is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form.
'Y' indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.
1)FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
The above syntax is used for changing the password for apps and applsys.Apps and applsys are database schemas of Oracle Applications.Alter user command should never be used to change the apps & applsys accounts.Oracle recommends using FNDCPASS only to change apps and applsys password.Please note that above command will change the password for both apps and applsys.
When we try to change the password, internally the following will take place.
a.Validations of current applsys & system password
b.Re-encrypt all password in FND_USER & FND_ORACLE_USERID
c.Update apps & applsys password in FND_ORACLE_USERID table.
d.Update DBA_USERS table as well.
2)FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
The above syntax is used for changing password for any other product schema like AP,AR,GL etc.
When we try to change the password, internally the following will take place.
a.Validations of current applsys & system password
b.update GL new password in FND_ORACLE_USERID table
c.Update DBA_USERS table as well.
3)FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME
The above syntax is used for changing the application level passwords like sysadmin etc. front end applications user password.
When we try to change the password, internally the following will take place.
a.Validations of current applsys & system password
b.Update VISION NEW password in FND_USER table.