ECXERROR Workflow Item Fails with ORA-6502 when Error Occurs in the Inbound Processing
(Doc ID 745177.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle XML Gateway - Version 11.5.10.0 to 11.5.10.4 [Release 11.5.10]Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
When XML Gateway fails while processing a XML message, an ECXERROR Workflow item is generated, which should report details of the failure to the XML Gateway Administrator, through an error notification.
That process works fine when the failure occurs while processing an outbound XML message. However, in the case of a failure happening for an inbound XML message, the ECXERROR item itself fails with the following error stack:
Failed Activity: Get ECX Out Error Details
Activity Type: Function
Error Name: ORA-6502
Error Message ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Error Stack: Wf_Engine.GetActivityAttrText(ECXERROR,
522271E45F5A0EC0E044001A4B075F5C, ECX_TRANSACTION_TYPE) ECX_WF_ERRORS.
GETOUTERRORDETAILS(ECXERROR, 522271E45F5A0EC0E044001A4B075F5C, 215260, RUN) Wf_Engine_Util.Function_Call(ECX_WF_ERRORS.GETOUTERRORDETAILS, ECXERROR,
522271E45F5A0EC0E044001A4B075F5C, 215260, RUN)
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |