My Oracle Support Banner

Unable To Purge Records Associated With OEOL In WF_ITEM_ACTIVITY_STATUSES_H Table (Doc ID 1072467.1)

Last updated on MAY 09, 2021

Applies to:

Oracle Order Management - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 18-JUL-2013***
***Checked for relevance on 29-DEC-2014***


On : 12.0.6 version, Transaction Control
Find users are unable to purge records associated with OEOL activity in WF_ITEM_ACTIVITY_STATUSES_H table using "Purge Obsolete Workflow Runtime Data" concurrent request.
bde_wf_data output shows huge number of records in 'Large activity History Status Item Keys'

Expect to be able to purge records in WF_ITEM_ACTIVITY_STATUSES_H associated with OEOL

The issue has the following business impact:
Due to this issue, users are getting table space issues because of the size of the table "WF_ITEM_ACTIVITY_STATUSES_H"


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.