My Oracle Support Banner

Sunopsis IKM Generates Incorrect 'GROUP BY' Clause When Mapped Fields Contain Parentheses (Doc ID 424676.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 3.2.03.11 to 3.2.03.22 [Release 3.2.03]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

The execution of an ODI (Sunopsis) Integration Interface having 'Source' or 'Staging area' mapped fields:

  1. with agregate functions (such as AVG, SUM ...) and
  2. with text / functions containing parentheses (such as 'Conso (hWh)' or 'to_char (S.age)')

fails on the 'Insert flow into I$ table' step.

The generated SQL order is incorrect (for example)

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.