End date unwanted users

Backup FND_USER table:

create table fnd_user_bkp_ddmmyy as select * from fnd_user;

Then:

DECLARE

CURSOR cur1

IS

SELECT user_name

FROM fnd_user

WHERE

user_name not in ('SYSADMIN', 'GUEST', 'MATHAN.MEYYAZHAGAN')

AND (end_date IS NULL OR TRUNC (end_date) > TRUNC (SYSDATE));

BEGIN

FOR all_user IN cur1

LOOP

fnd_user_pkg.updateuser (x_user_name => all_user.user_name,

x_owner => 'SYSADMIN',

x_end_date => SYSDATE

);

COMMIT;

END LOOP;

END;