Apply Hold: Local Event ERROR : Oracle.apps.ont.genesis.outbound.update (Doc ID 1920230.1)

Last updated on SEPTEMBER 14, 2020

Applies to:

Symptoms

When applying an Invoice Interface Hold on the line, and/OR SYSADMIN receives an error notification:

ERROR

To SYSADMIN
Sent 04-Aug-2014 18:28:31
ID 1234567

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)
Wf_Event.Enqueue(oracle.apps.ont.genesis.outbound.update, WF_EVENT_QH)
Wf_Event.Send(oracle.apps.ont.genesis.outbound.update)
Wf_Rule.Default_Rule(oracle.apps.ont.genesis.outbound.update, <ID>)
 
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.

Cause

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