Script to reset Oracle Apps frontend User ID Password

Script to reset Oracle Apps front end User ID Password

Here is a  sample anonymous PL/SQL block which will reset the Oracle Apps frontend password for a given user from backend



DECLARE
      flag_value BOOLEAN;
BEGIN
      flag_value :=
           fnd_user_pkg.changepassword(username=> 'NKUMAR2'
                                                 ,newpassword => 'welcome1');
     IF flag_value
     THEN
           DBMS_OUTPU.PUT_LINE('The password reset successfully');
     ELSE
           DBMS_OUTPUT.PUT_LINE('The password reset has failed');
     END IF;

END;
/
COMMIT;