My Oracle Support Banner

Unable to Sort XML ELEMENTS with the ODI XML Driver when Creating an XML File (Doc ID 424330.1)

Last updated on DECEMBER 04, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.


When creating an XML file with the ODI XML Driver, it is useful to be able to sort the relational schema, managed by the Driver before synchronizing the file to disk, in order that the XML Elements in the targeted file are set in a pre-defined order.

The documentation of the XML Driver describes a feature which creates additional columns (in the relational schema and which appear as attributes in the target XML file) called <tag_name>ORDER. These fields are for storing the appropriate numeric sorting keys and to allow the sort operation to function appropriately.

However, when setting these values to multiple values of 1 (1, 2 , 3, 4, ...), the sort operation does not function and the resulting XML Elements are not in the expected order.

Is there a problem with the XML Driver?




To view full details, 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 a vibrant support community of peers and Oracle experts.