My Oracle Support Banner

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.

Symptoms

Note that the grace period has ended for ODI releases where this issue may occur. It is recommended to upgrade to the latest version possible.
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:

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
References

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