Monday, March 19, 2018

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











In this post, we shared a script for another common production support activity. 

Action: To end date an existing application user.

Instance: R12.2.4

API: FND_USER_PKG.UPDATEUSER

Script:


DECLARE
    lc_user_name       VARCHAR2(100)  := 'SYSADMIN';
    ld_user_end_date   DATE  := SYSDATE;


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                => ld_user_end_date,
      x_password_date           => NULL,
      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;
/

 



1 Responses to “API to end date the User in Oracle Apps - FND_USER_PKG.UPDATEUSER”

Nil Bas said...
June 24, 2021 at 6:57 PM

I like to grab email address of user and notify user that your email address is end dated from Unix. Is there way to grab a email address of an user.

Thank you, Sunil


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.