My Oracle Support Banner

Cannot Map Between Two Different Sources In Same Target (Doc ID 2781990.1)

Last updated on JUNE 04, 2021

Applies to:

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

Goal

How to loop through different sources (input payloads) with instances that are correlated by key fields in OIC mapper?


E.g.  For a use case, Element Entry ID value should be mapped when ElementName in input_source_1 matches with BASE_ELEMENT_NAME in input_source_2

Input Source 1:
===============

<wd:Report_Data xmlns:wd="urn:com.workday.report/Allowance_Assignment_Structure">
   <wd:Report_Entry>
      <wd:AssignmentNumber>E00002021851</wd:AssignmentNumber>
      <wd:Allowance_Assignment>
         <wd:ElementName>Dummy_1</wd:ElementName>
      </wd:Allowance_Assignment>
      <wd:Allowance_Assignment>
         <wd:ElementName>Dummy_1</wd:ElementName>
      </wd:Allowance_Assignment>
   </wd:Report_Entry>
   
</wd:Report_Data>



Input Source 2:
================
<ReadResponse xmlns="http://xmlns.oracle.com/cloud/adapter/stagefile/Stage_Read_REQUEST/types">
   <DATA_DS xmlns="http://xmlns.oracle.com/cloud/adapter/nxsd/surrogate/Stage_Read">
      <G_1>
         <BASE_ELEMENT_NAME>Dummy_1</BASE_ELEMENT_NAME>
         <ASSIGNMENT_NUMBER>E00002021851</ASSIGNMENT_NUMBER>
         <ELEMENT_ENTRY_ID>1000000040</ELEMENT_ENTRY_ID>
         <ELEMENT_ENTRY_VALUE_ID>690</ELEMENT_ENTRY_VALUE_ID>
      </G_1>
      <G_1>
         <BASE_ELEMENT_NAME>Dummy_2</BASE_ELEMENT_NAME>
         <ASSIGNMENT_NUMBER>E00002021852</ASSIGNMENT_NUMBER>
         <ELEMENT_ENTRY_ID>1000000040</ELEMENT_ENTRY_ID>
         <ELEMENT_ENTRY_VALUE_ID>690</ELEMENT_ENTRY_VALUE_ID>
      </G_1>
   </DATA_DS>
</ReadResponse>

Solution

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
Goal
Solution
References


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