Friday, September 8, 2017

API to Update FND User (FND_USER_PKG.UPDATEUSER)

DECLARE
   lc_user_name                VARCHAR2 (100) := 'TEST';
   lc_user_password            VARCHAR2 (100) := 'Oracle123';
   ld_user_start_date          DATE := TO_DATE ('08-SEP-2017');
   ld_user_end_date            VARCHAR2 (100) := NULL;
   ld_password_date            VARCHAR2 (100) := TO_DATE ('08-SEP-2017');
   ld_password_lifespan_days   NUMBER := 90;
   ln_person_id                NUMBER := 32979;
   lc_email_address            VARCHAR2 (100) := 'TEST@xyz.com';
BEGIN
   FND_USER_PKG.UPDATEUSER (
      x_user_name                => lc_user_name,
      x_owner                    => NULL,
      x_unencrypted_password     => lc_user_password,
      x_start_date               => ld_user_start_date,
      x_end_date                 => ld_user_end_date,
      x_password_date            => ld_password_date,
      x_password_lifespan_days   => ld_password_lifespan_days,
      x_employee_id              => ln_person_id,
      x_email_address            => lc_email_address
   );

   COMMIT;
EXCEPTION
   WHEN OTHERS
   THEN
      ROLLBACK;
      DBMS_OUTPUT.PUT_LINE (SQLERRM);
END;
/

3 comments:

  1. can i get the same code by using cursurs

    ReplyDelete
  2. Anyone know how I can know which field was updated from a user at BD level?
    My mail dps.23b15ag@gmail.com

    ReplyDelete

API to Delete FND Application (FND_APPLICATION_PKG.DELETE_ROW)

BEGIN    FND_APPLICATION_PKG.DELETE_ROW (X_APPLICATION_ID => 20003); END; /