How to UPDATE
FND_USER PASSWORD in Oracle Apps EBS using API -  fnd_user_pkg.updateuser
DECLARE
    lc_user_name                  VARCHAR2(100)   :=
upper('XX123');
    lc_user_password              VARCHAR2(100)   :=
'welcome';
    ld_user_start_date            DATE            :=
TRUNC(SYSDATE)- 10;
    ld_user_end_date              VARCHAR2(100)   :=
NULL;
    ld_password_date              VARCHAR2(100)   :=
TRUNC(SYSDATE)- 10;
    ld_password_lifespan_days     NUMBER          :=
270;
    ln_person_id                  NUMBER          :=
NULL;
    lc_email_address              VARCHAR2(100)   :=
'heavendanish@gmail.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('Exception
in Update FND_USER API: '||SQLERRM);
END;

 
 
 
No comments:
Post a Comment