My Oracle Support Banner

ODI 12c "IKM SQL to SQL Incremental Update" Creates the I$ Table with Incorrect / Source Datatype when FLOW_TABLE_LOCATION=STAGING is Being Used (Doc ID 2554962.1)

Last updated on OCTOBER 02, 2023

Applies to:

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

Symptoms

The following error occurs in Oracle Data Integrator (ODI) 12c when attempting to use Oracle as a Staging Area for a Mapping that reads data from a source technology <SOURCE TECHNO> and writes to a target technology <TARGET TECHNO>:

One of the ways the issue can be reproduced at will is with the following steps:

  1. Create a Mapping that reads from a JDE source Datastore, and writes to a target SalesForce Datastore.
      
  2. On the Mapping "Physical" tab, use the genuine "IKM SQL to SQL Incremental Update".

    Set the IKM FLOW_TABLE_LOCATION option to STAGING, and pick a staging schema on Oracle technology.
       
  3. Execute the Mapping, and observe the error.

Changes

 

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.