Core Workflow - EBS (MOSC)

MOSC Banner

What tables are affected by setting the value for Core Workflow Only to "N" for the Purge Obsolete W

edited Nov 1, 2018 10:51AM in Core Workflow - EBS (MOSC) 8 commentsAnswered ✓

Hi,

I have over 18,000,000 closed AP Invoice Approval workflow items that I need to purge from the system.  We haven't been purging since the system went live several years ago - so needless to say we have accumulated a large number of records in the workflow tables.  One of the fields on the Purge Obsolete Workflow Runtime Data is "Core Workflow Only" - and the description for this field is "Core Workflow Only - Enter 'Y' to purge only obsolete runtime data associated with work items, or 'N' to purge all obsolete runtime data as well obsolete design data. The default is 'N'.".  If I set this value to "N" - based on the above description it will delete obsolete runtime data as well as obsolete design data.  For completed AP Invoice Approval workflows, if I invoke the purge request with "N" as the value for "Core Workflow Only"  - what tables will the data be deleted from?  

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