Last updated on MARCH 08, 2017
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
When applying an Invoice Interface Hold on the line,
SYSADMIN receives an error notification:
Sent 04-Aug-2014 18:28:31
An Error occurred in the following Event Subscription: Event Subscription
Event Error Name: -24033
Event Error Message: ORA-24033: no recipients for message
Event Error Stack:
Wf_Event_QH.Enqueue(APPS.WF_BPEL_Q, SQL err is ORA-24033: no recipients for message)
STEPS TO REPRODUCE
1. Order Management Responsibility
2. Sales Orders > Query Order
3. Navigate to line level
4. On line 1.1 > Actions > Apply Hold > Hold is applied (Line level Invoice Interface)
5. Notification is sent out.
Notifications are being sent to sysadmin user in Production instance - Local Event ERROR : oracle.apps.ont.genesis.outbound.update / 1461018
There are about 44,559 such open notifications in the WF_NOTIFICATIONS table.These are being sent to the Sysadmin user in Production and remain in Open state.
They are occupying a lot of space in WF tables and are becoming critical now from performance perspective as well. You need a solution to:
1. Get rid of existing ones
2. Stop these error notifications:--WF Purge program only purges CLOSED workflows.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms