My Oracle Support Banner

File to Netezza Function odiRef.getTable("FK_PK_TABLE_NAME") Shows Different Results in 11g Than in 12c (Doc ID 2682592.1)

Last updated on DECEMBER 20, 2023

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


After upgrading to ODI it is observed that a mapping with File to Netezza using function odiRef.getTable("FK_PK_TABLE_NAME") returns a different value in ODI 12c than it did in ODI

Issue can be confirmed with the following steps
Run the mapping in simulation mode and compare the output for ODI 12c and 11g.
Notice the value attributed as FK_TABLE is different in ODI 12c than it was in 11g.
For example:



Upgrade ODI to ODI


To view full details, 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 a vibrant support community of peers and Oracle experts.