ODI Mappings Using Nested Reusable Mappings (RMC) Multiple Times and where RMC is Without Output Signature are Missing Code when Executed (Doc ID 2369468.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

If an Oracle Data Integrator (ODI) 12c Reusable Mapping (RMC) without an output signature is used in another Reusable Mapping (nested), the tasks of the Reusable Mapping that have no output signature are not run the expected number of times.

For replicating the behavior:

1. Create a Reusable Mapping RU_MAP1, with target table as TABLE1 and without an output signature.
2. Create a Reusable Mapping RU_MAP2, which uses RU_MAP1 as well.
3. Create a Main Mapping, using RU_MAP2.
4. Generate code in Simulation, and notice that RU_MAP1 code is generated only once, while it is expected to generate twice.

Changes

Cause

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