Reset Password for Application User

DECLARE

v_user_name varchar2(30):=UPPER('VMALLAREDDY');

v_new_password varchar2(30):='welcome';

v_status BOOLEAN;

BEGIN

v_status:= fnd_user_pkg.ChangePassword (

    username => v_user_name,

    newpassword => v_new_password

);

IF v_status =TRUE THEN

dbms_output.put_line ('The password reset successfully for the User:'||v_user_name);

commit;

ELSE

DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));

ROLLBACK;

END IF;

END;