Wednesday 2 January 2019

How to UPDATE FND_USER PASSWORD in Oracle Apps EBS using API - fnd_user_pkg.updateuser


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

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...