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