Monday, March 19, 2018
API to end date the User in Oracle Apps - FND_USER_PKG.UPDATEUSER
In this post, we shared a script for another common production support activity.
Action: To end date an existing application user.
Instance: R12.2.4
API: FND_USER_PKG.UPDATEUSER
Script:
DECLARE
lc_user_name VARCHAR2(100) := 'SYSADMIN';
ld_user_end_date DATE := SYSDATE;
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 => ld_user_end_date,
x_password_date => NULL,
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;
/
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
1 Responses to “API to end date the User in Oracle Apps - FND_USER_PKG.UPDATEUSER”
June 24, 2021 at 6:57 PM
I like to grab email address of user and notify user that your email address is end dated from Unix. Is there way to grab a email address of an user.
Thank you, Sunil
Post a Comment