Script to Reset User Password from Backend

Script to Reset User Password from Backend 

fnd_user_pkg.changepassword 

Below is the anonymous block to reset password.

SET SERVEROUTPUT ON;


DECLARE

      flag BOOLEAN;

BEGIN

      flag := fnd_user_pkg.changepassword(username=> ''

                                          ,newpassword => '');

    IF flag

     THEN

           DBMS_OUTPUT.PUT_LINE('Your Password has been successfully reset');

     ELSE

           DBMS_OUTPUT.PUT_LINE('Password reset has failed');

     END IF;

END;

/



COMMIT;