PRC:PO: Cannot Submit PO for Approval Due to error: ORA-06512: FA_FUSION_SOAINFRA.EDN_ENQ_EVENT and ORA-19213: error occurred in XML processing (Doc ID 2959871.1)

Last updated on JULY 14, 2023

Applies to:

Symptoms

Cannot submit Purchase Order (PO) for Approval due to errors.

ERROR
-----------------------
An application error occurred. See the incident log for more information.

Error
java.sql.SQLException: ORA-31011: XML parsing failed ORA-06512: at "FA_FUSION_SOAINFRA.EDN_ENQ_EVENT_TO_AQJMS", line 444 ORA-19213: error occurred in XML processing at lines 386 LPX-00217: invalid character 2 (U+0002) ORA-06512: at "SYS.XMLTYPE", line 5 ORA-06512: at "FA_FUSION_SOAINFRA.EDN_ENQ_EVENT_TO_AQJMS", line 134 ORA-06512: at "FA_FUSION_SOAINFRA.EDN_JAVA_PUB_EVENT", line 12 ORA-06512: at line 1

Error
ORA-31011: XML parsing failed ORA-06512: at "FA_FUSION_SOAINFRA.EDN_ENQ_EVENT_TO_AQJMS", line 444 ORA-19213: error occurred in XML processing at lines 386 LPX-00217: invalid character 2 (U+0002) ORA-06512: at "SYS.XMLTYPE", line 5 ORA-06512: at "FA_FUSION_SOAINFRA.EDN_ENQ_EVENT_TO_AQJMS", line 134 ORA-06512: at "FA_FUSION_SOAINFRA.EDN_JAVA_PUB_EVENT", line 12 ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Process Requisitions > Select Requisition Line
2. Add to document Builder
3. Create PO
4. Edit PO > Manage Approvals to view approval tree
5. Submit PO and error occurs
6. PO is still in Pending Approval status
7. Click on Pending Approval hyperlink
Error:
The approvals information is currently unavailable. Try again later. (POR-2010363)
8. Withdraw and resubmit for Approval > same error occurs
6. In Transaction Console the only option available is to Terminate the process, but it still has to go through the Approval process, which results in the same error

Changes

Cause

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