Applying Patch 17919161 Errors ORA-24033 On WFXLoad.class
(Doc ID 2031209.1)
Last updated on MAY 19, 2024
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
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
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
| Symptoms |
| Cause |
| Solution |
| References |