My Oracle Support Banner

DB.XML Contains Missing Spaces In SAVED_QUERY.db.xml When Using Carriage Returns (Doc ID 1593542.1)

Last updated on MAY 06, 2022

Applies to:

Oracle Transportation Management - Version 6.3.1 and later
Information in this document applies to any platform.


On OTM version 6.3.1 when you create saved_queries in OTM containing 'carriage returns', and exporting using DB.XML, the carriage returns are NOT replaced by a space, which means incorrect SQLs in DB.XML.

Expect the return character to be replaced by a space, to maintain the integrity of the SQL.

The issue can be reproduced at will with the following steps:
1. Create a Saved Query in OTM via the User Interface, ensuring the SQL has several return characters.
2. Using DB.XML triggered by integration export the Saved Queries.
3. Note the files created have not replaced the return character with a space, this means when the file is uploaded to another system the SQL will not work.

The issue has the following business impact:
Due to this issue, users cannot migrate Saved Queries with custom SQL. The workaround is to put a space before all return characters in the Saved Query.


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.