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

Last updated on SEPTEMBER 20, 2017

Applies to:

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

Symptoms

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

ERROR

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

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, 5C80BCADFC26200CE0438BB91869200C)
 
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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms