My Oracle Support Banner

Unable to Purge Closed SERVEREQ Workflow Items (Doc ID 803192.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Workflow Cartridge - Version 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:

select item_type, count(*) 
from WF_ITEMS 
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. 


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.