DECLARE
lc_user_name VARCHAR2(100) := 'AFZAL_BAIG';
-- ld_user_end_date DATE := SYSDATE;
l_password varchar2(40) := '123456';
BEGIN
fnd_user_pkg.updateuser
( x_user_name => lc_user_name,
x_owner => NULL,
x_unencrypted_password => l_password,
x_start_date => NULL,
x_end_date => NULL,
x_password_date => to_date('2','J'), --forcing user to reset the password after the first login
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;
No comments:
Post a Comment