Unable To Purge Records Associated With OEOL In WF_ITEM_ACTIVITY_STATUSES_H Table
Last updated on JANUARY 31, 2018
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"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms