A Mapping Migrated From OWB Fails With "ORA-01790: expression must have same datatype as corresponding expression" In ODI 12C (Doc ID 2055201.1)

Last updated on MAY 12, 2017

Applies to:

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

Symptoms

Using Oracle Warehouse Builder (OWB) to Oracle Data Integrator (ODI) migration utility to migrate a few OWB projects to ODI.

In some of the migrated ODI 12.1.3 Mappings, a column mapping mismatch was observed in the SQL code generated by ODI during the Mapping execution. Hence following one-off patch was applied for resolving the problem:

<Patch 20607217> - LKM SQL to File: wrong code if set operator has desc order of attributes>

Though now, after having applied the above mentioned patch, the Mapping execution fails and signals: 

Caused By: java.sql.SQLSyntaxErrorException: ORA-01790: expression must have same datatype as corresponding expression
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
  ...

 

Cause

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 hundreds of Community platforms