Tuesday, October 29, 2019

API to end date the User in Oracle Apps - FND_USER_PKG.UPDATEUSER


Below script is used for updating User end date 


DECLARE
    lc_user_name       VARCHAR2(100)  := 'SGUDURU';
    ld_user_end_date   DATE  := SYSDATE+1000;
BEGIN
   fnd_user_pkg.updateuser
   (  x_user_name               => lc_user_name,
      x_owner                   => NULL,
      x_unencrypted_password    => NULL,
      x_start_date              => NULL,
      x_end_date                => sysdate+1000,
      x_password_date           => sysdate+1000,
      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;
/