ODI Does Not Reverse Engineer Properly The XSI:NILL XML Attribute (Doc ID 2304976.1)

Last updated on SEPTEMBER 13, 2017

Applies to:

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

Symptoms

Oracle Data Integrator (ODI) does incorrectly reverse engineer XML files with nillable (XSI:NILL) attributes: One Datastore is created by ODI for each "nil" attribute, while the DTD has the <!ATTLIST element_name xsi:nil (true) #IMPLIED> for each element_name.

Note nillable specifies whether an explicit NULL value can be assigned to an XML element. The NULL attribute is defined as part of the XML Schema Namespace.

Here a sample of DTD and XML file specifying a nillable (XSI:NILL) attribute:

The screenshot below shows an example for the incorrect behavior reversing the "XSI:NILL" versus correct reversed Model for the same object is reversed removing the "XSI:NILL":

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