|
|
Dear Erman,
We are getting information on all wf_error notifications. We ran the below query and got the below output. Parent_status shows NO PARENT for last row in the output. Can you please make us understand what does it mean.
select c.item_type child, decode(c.end_date,null,'OPEN','CLOSED') child_status, c.parent_item_type parent, decode(c.parent_item_type,null,'NOPARENT',decode(p.end_date,null,'OPEN','CLOSED')) parent_status,
count(*)
from
wf_items p,
wf_items c
where
p.item_type(+) = c.parent_item_type
and p.item_key(+) = c.parent_item_key
and c.item_type='WFERROR'
group by c.item_type, decode(c.end_date,null,'OPEN','CLOSED'), c.parent_item_type ,
decode(c.parent_item_type,null,'NOPARENT',decode(p.end_date,null,'OPEN','CLOSED'))
order by c.item_type , c.parent_item_type;
CHILD CHILD_ PARENT PARENT_S COUNT(*)
------- ------ -------- -------- ----------
WFERROR CLOSED APINVAPR CLOSED 1775
WFERROR OPEN APINVAPR CLOSED 1611
WFERROR OPEN APINVAPR OPEN 877
WFERROR OPEN GLBATCH CLOSED 63
WFERROR OPEN IGSPE002 OPEN 29042
WFERROR OPEN POAPPRV CLOSED 121
WFERROR OPEN POAPPRV OPEN 9
WFERROR OPEN POERROR CLOSED 2
WFERROR OPEN POERROR OPEN 1
WFERROR OPEN POWFPOAG OPEN 27
WFERROR OPEN POWFRQAG OPEN 132
CHILD CHILD_ PARENT PARENT_S COUNT(*)
------- ------ -------- -------- ----------
WFERROR CLOSED REQAPPRV CLOSED 18
WFERROR OPEN REQAPPRV CLOSED 111
WFERROR OPEN REQAPPRV OPEN 10149
WFERROR OPEN TTDAPNOT CLOSED 1752
WFERROR OPEN TTDAPNOT OPEN 10
WFERROR OPEN NOPARENT 2318820
17 rows selected.
Is it safe to purge them? Please advice.
Thanks & Regards,
Prabhu
|
Locked
