Oracle EBS set change Password with SQL

2026-03-24 Oracle EBS r12.2

SET SERVEROUTPUT ON
DECLARE
  v_success BOOLEAN;
BEGIN
  v_success := fnd_user_pkg.ChangePassword(
                 username => 'SYSADMIN',
                 newpassword => 'P@ssW0rd'
               );

  IF v_success THEN
    DBMS_OUTPUT.PUT_LINE('Change Success!');
    COMMIT;
  ELSE
    DBMS_OUTPUT.PUT_LINE('Change Fail!');
    ROLLBACK;
  END IF;
END;
/