Purge of PO APPROVAL workflow's
The Purge of PO APPROVAL workflow's is set to purge workflows older than 180 days.
There are only 669,773 POAPPRV that are currently active, yet we have over 92.5 million OPEN in the wf_item_attribute_values table.
select item_type,count(*) from wf_item_attribute_values group by item_type;
It appears that the POAPPRV are not being puged and are accumulating in the WF_ITEM_ATTRIBUTE_VALUES table (over 92.5 million) and in the WF_ITEM_ACTIVITY_SATATUSES table (20,708,927).
How do I safely purge the POAPPRV from the WF_ITEM_ATTRIBUTE_VALUES and the WF_ITEM_ACTIVITY_SATATUSES table?
Thanks,
Paul