My Oracle Support Banner

Unable to Purge OMERROR Notifications Associated with Closed Order Lines (Doc ID 2681584.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Customer is seeking assistance to address a large volume of OMERROR messages

SQL> select message_type, count(*) from wf_notifications
where status in ('OPEN', 'CANCELED')
and mail_status in ('MAIL', 'INVALID')
and begin_date < (sysdate-30)
group by message_type;

MESSAGE_ COUNT(*)
-------- --------
OMERROR  5830840


These are notifications, but they need to ensure that the root cause is stopped (so that no further notifications are created)
and they need to close and purge this OMERROR volume

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.