After Upgrade from 11g Incorrect GROUP BY Is Generated For ODI 12c Mappings Using CONCAT Operation (Doc ID 2291870.1)

Last updated on AUGUST 01, 2017

Applies to:

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

Symptoms

Integration Interfaces using the CONCAT character function were successfully running in Oracle Data Integrator (ODI) 11g.

After upgrading to ODI 12.2.1.2.6 Mappings, the generated code contains a GROUP BY, which is incorrect.

Note the behavior is also observed when smart exporting the Integration Interface from ODI 11g, and importing into ODI 12c.

Changes

 

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