|
|
On R12.2.9 DB 19.9c on AIX
Here is our situation:
SQL> SELECT COUNT(*) FROM wf_notifications where message_type='OMERROR' and status='OPEN';
COUNT(*)
----------
7439
Following How To Purge End Dated OMERROR Workflow (Doc ID 2302627.1) I run
SQL>@ont0058.sql
WFERROR COUNT BEFORE
--------------------
0
OMERROR COUNT BEFORE
--------------------
0
PL/SQL procedure successfully completed.
WFERROR COUNT AFTER
-------------------
0
OMERROR COUNT AFTER
-------------------
0
And run Purge Order Management Workflow with the following parameters
Workflow Item Type : OM Error
Attempt to Close : Yes
, but we have still:
SQL> SELECT COUNT(*) FROM wf_notifications where message_type='OMERROR' and status='OPEN';
COUNT(*)
4964
Any suggestion?
Thanks.
|
Locked
