Script to reset the user password in Oracle Apps.

Script to reset the user password in Oracle Apps.

DECLARE
   flag_value   BOOLEAN;
BEGIN
   flag_value :=
      fnd_user_pkg.
       changepassword (username => '&User_Name', newpassword => 'welcome1');

   IF flag_value
   THEN
      DBMS_OUTPUT.PUT_LINE ('The password reset successfully');
      COMMIT;
   ELSE
      DBMS_OUTPUT.PUT_LINE ('The password reset has failed');
   END IF;
END;
/