Below script is used for updating User end date
DECLARE
lc_user_name VARCHAR2(100) := 'SGUDURU';
ld_user_end_date DATE := SYSDATE+1000;
BEGIN
fnd_user_pkg.updateuser
( x_user_name => lc_user_name,
x_owner => NULL,
x_unencrypted_password => NULL,
x_start_date => NULL,
x_end_date => sysdate+1000,
x_password_date => sysdate+1000,
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;
/
lc_user_name VARCHAR2(100) := 'SGUDURU';
ld_user_end_date DATE := SYSDATE+1000;
BEGIN
fnd_user_pkg.updateuser
( x_user_name => lc_user_name,
x_owner => NULL,
x_unencrypted_password => NULL,
x_start_date => NULL,
x_end_date => sysdate+1000,
x_password_date => sysdate+1000,
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;
/
H150-oracle-dba-interview-questions
ReplyDeleteHow to fix ORA-28368: cannot auto-create wallet
Your website is for sure worth bookmarking.Small Business ERP Software
ReplyDeleteGenerally, we will in general partner innovation with the more youthful age, yet, more established grown-ups are shockingly capable with a scope of present day innovation. For instance, 59% of Americans matured 65 or more go on the web and 77% of this populace use cellphones.
ReplyDeletexender
It is included in my habit that I often visit blogs in my free time, so after landing on your blog. I have thoroughly impressed with it and decided to take out some precious time to visit it again and again. Thanks. Expert secrets
ReplyDeleteWhat a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. note taking apps
ReplyDelete