Unable to Purge OMERROR Notifications Associated with Closed Order Lines
(Doc ID 2681584.1)
Last updated on AUGUST 19, 2021
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
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;
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
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