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 04, 2022

Applies to:

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


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(
  at oracle.jdbc.driver.T4CTTIoer.processError(
  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.


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.