My Oracle Support Banner

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

Last updated on OCTOBER 04, 2022

Applies to:

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


In Oracle Data Integrator (ODI), 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


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

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