Script to reset User password in Oracle Applications

Script to reset user password in oracle applications

We can use the in build API to reset the user password from backend.

API: fnd_user_pkg.changepassword this API accepts two parameters one is USER NAME and other is New Password.

Below is the anonymous block to reset password.

SET SERVEROUTPUT ON;

DECLARE

      flag BOOLEAN;

BEGIN

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

                                          ,newpassword => 'Monday123');

    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;

Below are the screenshots for your reference.