AOL: Script to reset fnd user login password from backend in Oracle

AOL: Script to reset password from backend in Oracle 

The below script is a ready to use script, you can set the new password according to your company password policy. 

/************************************************************

*PURPOSE: To change the   password of a user from backend(DB)   *

*AUTHOR: Arokia Antony Jayaraj                              *

*************************************************************/

SET serveroutput ON;

DECLARE

  v_user_name    VARCHAR2(30):= UPPER('SYSADMIN');

  v_new_password VARCHAR2(30):= 'oracle123';

  v_status       BOOLEAN;

BEGIN

  v_status   := fnd_user_pkg.ChangePassword ( username => v_user_name, 

                                              newpassword => v_new_password 

                                            );

  IF v_status  THEN

    dbms_output.put_line ('The password reset successfully for the entered User:'||v_user_name);

    COMMIT;

  ELSE

    DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));

    ROLLBACK;

  END IF;

END;