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

Last updated on SEPTEMBER 02, 2016

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***

Symptoms

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'

EXPECTED BEHAVIOR
-----------------------
Expect to be able to purge records in WF_ITEM_ACTIVITY_STATUSES_H associated with OEOL

BUSINESS IMPACT
-----------------------
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"

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms