How to Delete Users from FND_USER in oracle apps

Sometimes it is required to purge a user or set of users from EBS and manual task can be tedious or laborious. Here is a simple way of purging such users from the system.

DECLARE BEGIN FOR X IN (select * from fnd_user where user_name in ('DUMMY_USER') LOOP DELETE FROM fnd_user where user_name=X.user_name;     fnd_function_security_cache.delete_user(X.user_id); END LOOP; END;