Search This Blog

Monday, June 30, 2025

Oracle EBS Update FND_USER user password

 DECLARE

    lc_user_name       VARCHAR2(100)  := 'AFZAL_BAIG';

--    ld_user_end_date   DATE  := SYSDATE;

l_password varchar2(40) := '123456';



BEGIN

   fnd_user_pkg.updateuser

   (  x_user_name               => lc_user_name,

      x_owner                   => NULL,

      x_unencrypted_password    => l_password,

      x_start_date              => NULL,

      x_end_date                => NULL,

      x_password_date           => to_date('2','J'), --forcing user to reset the password after the first login

      x_password_lifespan_days  => NULL,

      x_employee_id             => NULL,

      x_email_address           => NULL

   );


 COMMIT;



EXCEPTION

  WHEN OTHERS THEN

    ROLLBACK;

    DBMS_OUTPUT.PUT_LINE(SQLERRM);

END;

No comments:

Post a Comment