My Oracle Support Banner

ODI Custom KM Ignored if Reusable Mapping is Joined with Dataset in Mapping (Doc ID 2767751.1)

Last updated on APRIL 23, 2021

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12.2.1.4, even though a custom KM is specified to be used as XKM, this is being ignored if a reusable mapping is used as source and joined with another table.
If there is no join with another table, the code is generated correctly using the custom KM.

ODI should generate the code using the specified KM.


The issue can be reproduced at will with the following steps:

  1. In ODI Studio, create a reusable mapping with set component
  2. Create a mapping and use the reusable mapping as source
  3. In a dataset, join the reusable mapping with a datastore
  4. Target to another table
  5. In "Physical" tab, set the custom KM to be used as XKM
  6. Run the mapping in simulation mode and observe that the custom KM is not used

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
References


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