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 MAY 25, 2021

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>:

ODI-1227: Task Create flow table I$-IKM SQL to SQL Incremental Update- fails on the source connection <ORACLE STAGING TABLE>.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at ...

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.

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.