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

Last updated on JUNE 23, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Manage Expenses

When attempting to load XML
the following error occurs.

ERROR
-----------------------
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 &)


STEPS
-----------------------
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


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

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