All About FNDCPASS

To change Apps Password

FNDCPASS apps/ 0 Y system/ SYSTEM APPLSYS 

Syntax:

FNDCPASS apps/apps  0 Y system/manager SYSTEM APPLSYS <Password>

Ex :

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

To change an application schema password

Syntax:
FNDCPASS apps/apps  0 Y system/manager ORACLE  <Schema Name> <Schema Password> 

EX :

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

To change all application schema passwords at once.

This feature is available from 11i.ATG_PF.H Rollup 3.

Syntax :

FNDCPASS apps/ 0 Y system/ ALLORACLE <Schema Password>

Ex :

FNDCPASS apps/apps123 0 Y system/manager123 ALLORACLE schemapass123

To change an Application User (EBS Fornt – End) Password

Syntax :

FNDCPASS apps/apps 0 Y system/manager USER <Password>

Ex :
FNDCPASS apps/apps 0 Y system/manager USER ADITHIYAN ORACLEAPPSDBA

Please note that when we changing the apps password it is very important to run autoconfig to make the changes in across all the application or you will need change the apps password in following files manually if it exists.

 $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
 $FND_TOP/resource/wfmail.cfg
 $COMMON_TOP/admin/scripts/adcmctl.ch
 $OA_HTML/bin/appsweb.cfg
 $AD_TOP/admin/template/CGIcmd.dat


Changing Password Using Query

Note : It is not Recommended

begin
if fnd_user_pkg.changepassword('RAJSHEKHAR','welcome@123') then
null;

end if;
end;

Enable User

begin
exec fnd_user_pkg.enableuser('RAJSHEKHAR',sysdate,sysdate+1000) then
commit;

end;