Error Using ODI JKM Oracle Simple Or Consistent On Tables With PK Defined On All Columns
(Doc ID 732795.1)
Last updated on JUNE 16, 2022
Applies to:Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.
For more information reference: <Document 456313.1> Primary Note For Oracle Data Integrator (ODI) and Legacy Sunopsis, Releases and Patches
When using the "JKM Oracle Simple" or "JKM Oracle Consistent" provided by Oracle Data Integrator (ODI) on a table made by columns which are all part of the Primary Key, the "Create View" step generates a wrong code.
For example, if MYTABLE is composed by only two columns (MYCOL1 and MYCOL2) and both of them build the PK, the SQL code generated by ODI contains a comma after the latest column in the Select order, which is syntactically incorrect:
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