Change Sysadmin Password in Oracle Apps from sqlplus

Change Sysadmin Password in Oracle Apps from sqlplus

I am sharing the below on how to change SYSADMIN password and Application User Login passwords using fnd_user_pkg from backend. 

fnd_user_pkg tool: This package maintains oracle application user accounts

Script:

Connect as apps user to sqlplus

sqlplus apps/apps

declare

var_l boolean;

begin

var_l=fnd_user_pkg.change_password('sysadmin','sysadmin_new_pwd');

end;

/

You can verify from backend that password has changed successfully or not without login to the application.

select fnd_web_sec.validate_login('sysadmin','sysadminpwd') from dual;

It should returns 'Y'.

If you like please follow and comment