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 184.108.40.206.6 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>:
One of the ways the issue can be reproduced at will is with the following steps:
- Create a Mapping that reads from a JDE source Datastore, and writes to a target SalesForce Datastore.
- 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.
- 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