OMERROR notifications

[big]

Hi,
On R12.2.9 DB 19c on AIX, installed from scratch

we have 7293 open error notifications:

SQL> select message_type, count(*) from WF_NOTIFICATIONS where status='OPEN' and message_type='OMERROR' group by message_type;

MESSAGE   COUNT(*)
------- ----------
OMERROR       7293

When we try to close in html interface we receive:



What can we do?

Thanks and regards.

[ErmanArslansOracleBlog]

Did you check the following community thread?

https://community.oracle.com/mosc/discussion/3646938/how-to-purge-om-error-notifications

[big]

Hi,
Thank you.

In that post it is said:
"The Purge program can purge only items that are closed"

Then if they are not closed (our case) they cannot be purged.

The question is yet how to close 7293 notifications?

Regards.

[ErmanArslansOracleBlog]

Did you check the following? ->

How to Purge Workflow Notifications of OM Error (OMERROR) (Doc ID 2173917.1)

[big]

Hi
Thank you.

In 2173917.1
I followed :
System Administrator >Workflow>Transaction Monitor> Oracle Application manager> Workflow Manager Under Workflow Metrics> Work Items> Click on show (link) , then under 'throughput' click on >Work Items and choose from VIEW LOV Select  'Errored Work Items' , search for Error Item Type for example 'OM Error' and Click on it and then click on View Details.
Here you have options
Abort All , Retry All Or Abort or Retry specific one.
And I had:



Regards.

[ErmanArslansOracleBlog]

What about the following one ?->

bde_wf_clean_worklist.sql - Cleans Out The Worklist of Obsolete Notifications (Doc ID 255048.1)

& did you run the Purge Order Management Workflow?

-- Workflow Item Type : OM Error
--Attempt to Close   : Yes - This will  set the end_date for the Item_key in WF_ITEMS and make it eligible for purging.

[big]

Thank you.

As I indicated in my duplicate poste:

Purge End Dated OMERROR Workflow

I ran 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
I did not run bde_wf_clean_worklist.sql.

Regards.

[ErmanArslansOracleBlog]

Did you go through the following document? ->

How To Purge End Dated OMERROR Workflow (Doc ID 2302627.1)