Search This Blog

Tuesday, May 17, 2022

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;                         


No comments:

Post a Comment