--oracle apps reset password from backend
DECLARE
p_change BOOLEAN;
v_user VARCHAR2(400) := 'Support';
v_new_password VARCHAR2(400) := 'inJG@2019';
BEGIN
p_change := fnd_user_pkg.changepassword(username => v_user, newpassword => v_new_password);
IF p_change THEN
dbms_output.put_line('Password has been successfully reset for user ' || v_user);
ELSE
dbms_output.put_line('Password reset has been failed for user ' || v_user);
END IF;
COMMIT;
END;