Unable to Purge Closed SERVEREQ Workflow Items
Last updated on OCTOBER 04, 2016
Applies to:Oracle Workflow Cartridge - Version 220.127.116.11 to 12.2.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
EXECUTABLE:FNDWFPR - Purge Obsolete Workflow Runtime Data
Checked for relevance on 21-SEP-2013
Although the Purge Obsolete Workflow Runtime Data concurrent program is periodically run, a number of closed SERVEREQ items keep on increasing in the WF_ITEMS table.
This can be checked by running the following script at different intervals:
where END_DATE IS NOT NULL
and item_type = 'SERVEREQ'
group by item_type;
Alternatively one can check the number of the closed SERVEREQ workflow items in bde_wf_data.sql script output (see <NOTE:165316.1> " bde_wf_data.sql - Query Workflow Runtime Data That Is Eligible For Purging").
This problem often results in huge volumes in WF_ITEM_ATTRIBUTE_VALUES table then leading to performance issues.
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