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