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:
- with agregate functions (such as AVG, SUM ...) and
- 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 |