My Oracle Support Banner

The DB.XML Export Query Result Does Not Return All the Specified Columns in the SQL Query. (Doc ID 2566100.1)

Last updated on JUNE 27, 2023

Applies to:

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

Symptoms

The DB.XML Export (Export Object Type: Query) result does not return all the specified columns in the SQL Query.

EXAMPLE:
------------
Business Process Automation > Data Import/Export > DB.XML Export

Export Object Type: Query

SQL Query: select ORDER_RELEASE_GID, INSERT_USER, INSERT_DATE, UPDATE_USER, UPDATE_DATE from Order_release

Root Name: document_content

Run

Result only includes ORDER_RELEASE_GID

NOTE: This applies to the remote DB.XML Export query (glog.integration.servlet.DBXMLServlet?command=xmlExport).

Cause

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
Symptoms
Cause
Solution


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