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;
/

3 comments:

  1. Generally, we will in general partner innovation with the more youthful age, yet, more established grown-ups are shockingly capable with a scope of present day innovation. For instance, 59% of Americans matured 65 or more go on the web and 77% of this populace use cellphones.
    xender

    ReplyDelete