My Oracle Support Banner

"For Each" Mapping Issue - All Data From Repeating Node Is Being Written To Target, Instead Of Just One Instance (Doc ID 2540973.1)

Last updated on FEBRUARY 10, 2020

Applies to:

Oracle Integration-OIC - Version 18.2.5 to 18.2.5
Information in this document applies to any platform.

Symptoms

"For Each" Mapping Issue:  All data from the repeating node Is being written to the target, instead of just one instance (or iteration).

For example:

Source payload:

<SyncReadFileResponse
  <FileReadResponse
     <FTPResponseHeader>
          <fileName>MyFile.csv</fileName>
          <directory>Test</directory>
     </FTPResponseHeader>
     <write_rec_Set
          <write_rec>
              <C1>1</C1>
              <C2>XXX</C2>
          </write_rec>
          <write_rec>
              <C1>2</C1>
              <C2>YYY</C2>
          </write_rec>
          <write_rec>
               <C1>3</C1>
               <C2>ZZZ</C2>
          </write_rec>
     </write_rec_Set>
  </FileReadResponse>
</SyncReadFileResponse>

The first "For each" xml fragment looks like this:

<write_rec xmlns="http://TargetNamespace.com/fileReference/read">[[
  <C1>1</C1>
  <C2>XXX</C2>
</write_rec>

After mapping the source to the target, it's copying the data from all the repeating instances instead of just one:

<nstrgmpr:XxOicTest>
       <nstrgmpr:id>1 2 3</nstrgmpr:id>
       <nstrgmpr:name>XXX YYY ZZZ</nstrgmpr:name>
   </nstrgmpr:XxOicTest>


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.