How To Change Password of Naming User without login on Application R12

Note:

You may change the password of naming users in Oracle E-Business Suite R12 (Application) without Login on Application from the backend. 

Connect Apps/Apps@PROD 

 DECLARE 

  l_ret_val   BOOLEAN; 

  l_user_name varchar2(50) := '&USER_NAME'; 

  l_new_pwd   varchar2(20) := '&PASSWORD'; 

BEGIN 

  l_ret_val := fnd_user_pkg.changepassword(username    => l_user_name, newpassword => l_new_pwd); 

  IF l_ret_val THEN 

    DBMS_OUTPUT.PUT_LINE('The password is successfully reset to ' || l_new_pwd); 

    COMMIT; 

ELSE 

    DBMS_OUTPUT.PUT_LINE('The password reset has failed'); 

  END IF; 

END;