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. For example, we can change the APPS password using FNDCPASS and also any other schema in the EBS database. FNDCPASS can also be used to change the password of an application user (like sysadmin).
FNDCPASS uses four modes to change application schema passwords.
(i) SYSTEM ,It is used to change APPS/APPLSYS password
(ii) USER , It is used to change oracle applications user like SYSADMIN
(iii) ORACLE, It is used to change the password of oracle schema like GL,AP
(iv) ALLORACLE , It is used to change all passwords of all schema.
Chaging password using fndpass utility in oracle apps 2012-01-19
Chaging password using fndpass utility in oracle apps