Purge End Dated OMERROR Workflow

Posted by big on Apr 14, 2023; 3:09pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Purge-End-Dated-OMERROR-Workflow-tp11786.html

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.