Reset the password of user in Oracle apps

 

Use the below code to reset the password

DECLARE
    v_status BOOLEAN ;
BEGIN
    X:= FND_USER_PKG.CHANGEPASSWORD('XX63','welcome123');
    IF v_status THEN
        dbms_output.put_line('true');
        COMMIT;
    ELSE
        dbms_output.put_line('flase');
    END IF;
END;

Here XX63 is username and welcome123 is new password