My Oracle Support Banner

Getting Error When Loading XML File Generated By Fusion Expense In To Oracle Through Sql Loader (Doc ID 2279858.1)

Last updated on AUGUST 04, 2022

Applies to:

Oracle Fusion Expenses Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Manage Expenses

When attempting to load XML
the following error occurs.

Record 1: Rejected - Error on table DPLI_XML_TAB.
ORA-64464: XML event error
ORA-19202: Error occurred in XML processing
In line 1363 of orastream:
LPX-00242: invalid use of ampersand ('&') character (use &)

The issue can be reproduced at will with the following steps:
1) Customer exports the ExpenseReport XML from the Fusion expense Cloud
using the UCM File Import and Export feature (FinExmExportERToAPJob)
2) Process the file from the Fusion expense Cloud into EBS AP Interface using SQL loader
3) Then import the data as an AP Invoice

The issue has the following business impact:
Due to this issue, users cannot get the XML loaded


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

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