Purge Order Management Workflow

Hi,

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) (Thanks to Vyshali) I run

@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';