Workflow Purge Does Not Remove Records From WF_ITEM_ACTIVITY (Doc ID 315972.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Workflow Cartridge - Version 11.5.1 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
wfprgb.pls
FNDWFPR
Checked for relevance on 21-SEP-2013


Symptoms

The concurrent program "Purge Obsolete Workflow Runtime Data" is running every day with following parameters: 

Item type: blank, Item key: blank, Age = 30, Persistence type: blank, runtime:  blank

yet the workflow data tables keep growing. 

In the Oracle Applications Console there are over 1.8 million purgeable rows showing in the Work Items Throughput for Completed Items.

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