My Oracle Support Banner

Unable to Consume Repetitive Elements from XML in ODI (Doc ID 1669344.1)

Last updated on OCTOBER 04, 2023

Applies to:

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

Symptoms

While loading data from XML, Oracle Data Integrator (ODI) is unable to parse the repetitive elements properly. If an element is repeating more than once the last value of the element is picked.

Example:

In the block above the element "detail" is repeating three times, and three rows are expected after parsing the XML.But only one row is present in output with value 'O' which is the last repetition.

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!

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