Applying Patch 17919161 Errors ORA-24033 On WFXLoad.class (Doc ID 2031209.1)

Last updated on DECEMBER 08, 2016

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2Cloud]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 12.2.4 version,
the WFXLoad.class jobs fails during a 12.2.4 upgrade while applying Patch 17919161 with the following error:

Error Stack:
Wf_Event.Dispatch(oracle.apps.wf.event.event.update)
Wf_Events_Pkg.Update_Row(D05ACC0D7996A647E030B98BD77F6799, oracle.apps.ecx.inbound.message.process, EVENT)
Wf_Events_Pkg.Load_Row(19D7EAAE01376000E05303F9DC0A44C3, oracle.apps.ecx.inbound.message.process, EVENT)
Wf_Events_Pkg.Receive(<WF_TABLE_DATA>
<WF_EVENTS>
  <VERSION>1.0</VERSION>
  <GUID>#NEW</GUID>
  <NAME>oracle.apps.ecx.inbound.message.process</NAME>
  <TYPE>EVENT</TYPE>
  <STATUS>ENABLED</STATUS>
  <GENERATE_FUNCTION/>
  <OWNER_NAME>Oracle Workflow</OWNER_NAME>
  <OWNER_TAG>ECX</OWNER_TAG>
  <CUSTOMIZATION_LEVEL>L</CUSTOMIZATION_LEVEL>
  <LICENSED_FLAG>Y</LICENSED_FLAG>
  <JAVA_GENERATE_FUNC/>
  <DISPLAY_NAME>Generic Inbound Message Process Event</DISPLAY_NAME>
  <DESCRIPTION>Generic Inbound Message Process Event</DESCRIPTION>
  <IREP_ANNOTATION/>
</WF_EVENTS>
</WF_TABLE_DATA>
)
Exception encountered in execWFXLoad - (String args[], Connection appsConn): SQL Exception encountered: ORA-24033: no recipients for message
ORA-06512: at "APPS.WF_EVENTS_PKG", line 642
ORA-06512: at "APPS.WF_EVENT_SYNCHRONIZE_PKG", line 1194
ORA-06512: at line 1


The issue can be reproduced at will with the following steps:
1. Apply patch 17919161 (12.2.4 upgrade patch).


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