My Oracle Support Banner

No SQL Code is Generated in ODI 12c IKM Oracle Merge at Code Generation Time (Doc ID 1966759.1)

Last updated on OCTOBER 02, 2023

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.1.3.0.170418 [Release 12c]
Information in this document applies to any platform.

Symptoms

When executing an Oracle Data Integrator (ODI) mapping using IKM Oracle Merge knowledge module, the code from this module does not show in the session logs in the Operator and nothing is executed.

When Under Logical view, target table > Target > Integration Type is set to None. IKM Oracle Merge gets automatically selected, and no code shows up. When integration type is set to Control Append, IKM Oracle Insert is selected and code is generated.

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!

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