ODI 12c Substitution Method odiRef.getPK("KEY_NAME") Returns 'odiRef.getPK does not support multiple primary keys' When The Datastore Primary Key is Defined on Two or More Columns (Doc ID 1944562.1)

Last updated on JUNE 28, 2016

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12c, the call to odiRef.getPK("KEY_NAME") incorrectly ends with below message for a Datastore that has the Primary Key constraint defined on more then one column:

odiRef.getPK does not support multiple primary keys

Cause

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 hundreds of Community platforms