WFERROR in R12.2.5

Posted by prabhunoule on Nov 08, 2023; 10:38am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/WFERROR-in-R12-2-5-tp12167.html

Hi Erman,

We are on R12.2.5 version.

SELECT count(*)
 FROM wf_items
WHERE item_type = 'WFERROR'
AND end_date is null
AND begin_date <= sysdate-360;

Output: 2356993

Can we purge these 1 year old wferror?



Thanks & Regards,
Prabhu