Core Workflow - EBS (MOSC)

MOSC Banner

Purge of PO APPROVAL workflow's

edited Feb 25, 2014 6:47PM in Core Workflow - EBS (MOSC) 7 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center