Delete fnd_user in oracle apps r12

This is not recommended nor supported.

Use as last option, after testing.

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

END;