Anyone know what drives the counts in EBS wf_item_types, i.e. wf_item_types.num_rows?? Ours seem ou

Curious if anyone knows what drives the various counts in the wf_item_types table, for example the wf_item_types.num_rows value.  If there could be any corruption w/that value that could cause any other problems?

For example, we have the following data in wf_item_types:

Item Type: WFERROR, NUM_ACTIVE: 5,005,275

(This shows up like a sore thumb on our Workflow Analyzer output).

However, in looking at the count of WFERROR records in wf_items we get:

select count(rowid) 

from wf_items 

where item_type = 'WFERROR';

COUNT(ROWID)

------------

       37299 

(ok, yeah, probably still too many...we're working on that!)