"XML Parsing Error: not well-formed" Generated trying to Export Data from OTM that Contains the '&' Symbol

(Doc ID 2250500.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Transportation Management - Version 6.3.7 and later
Oracle Transportation Management Cloud Service - Version 6.4.1 and later
Information in this document applies to any platform.

Symptoms

When the '&' symbol is used in a field, like the location name, agent description and many others in OTM, the data will no longer be able to be exported to the UI using the CSV Export feature.

The following in an example of the typical error that would be generated.

XML Parsing Error: not well-formed
Location: http://<your server>.com:<your port>/GC3/glog.integration.servlet.CSVUtilServlet/1490307560383?ct=NjI1MjAxODc5NDUwNTczNzI5NA%3D%3D&bcKey=MTQ5MDMwNzU2MDM4Njow
Line Number 18, Column 19:"KAW.AMP","AMP","&",,,,,"USA",,,,,"America/Denver",,,,,,,,"N","N","N",,"N","U",,,,,,"N",,,"KAW","KAW.ADMIN","20170323220522","KAW.ADMIN","20170323221307",,,,,,,"N",,"N",,,,,,,"N",,,,,,,,,"N",,,,,"N",1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"Y",
------------------^

 

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