How to reset Oracle Applications User Password using PL/SQL?

Declare

vStr varchar2(2000);

Begin

vstr := apps.fnd_web_sec.change_password(p_user => ‘<UserName>’,p_new_pwd => ‘<NewPassword>’,p_autonomous => true);

dbms_output.put_line(‘vstr ‘||vstr);

End;

/

Example

Declare

vStr varchar2(2000);

Begin

vstr := apps.fnd_web_sec.change_password(p_user => ‘SYSADMIN’,p_new_pwd => ‘SysAdm1n’,p_autonomous => true);

dbms_output.put_line(‘vstr ‘||vstr);

End;

/