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
Machine Learning Projects for Final Year machine learning projects for final year
DeleteDeep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Deep Learning Projects for Final Year even arrange a more significant compensation.
Python Training in Chennai Project Centers in Chennai
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