"Component KM XKM Oracle Lookup: Path specifier is ambiguously defined" Message Is Signalled When Executing An ODI 12.2.1 Mapping Migrated from OWB (Doc ID 2118894.1)

Last updated on JUNE 02, 2017

Applies to:

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

Symptoms

Converting from Oracle Warehouse Builder (OWB) 11.2.0.4 to Oracle Data Integrator (ODI) 12.1.3.0.0, then upgrading the Repositories to ODI 12.2.1.0.0

A Mapping upgraded to ODI 12.2.1 is getting validated without any error.

Though following error is received when executing it (or generating the Scenario), without a Session to be started:

Error when calling generation delegate for component KM XKM Oracle Lookup: Path specifier is ambiguously defined.
There are too many (or no) possible downstream candidate points starting from: OutputConnectorPoint UNION_ALL.OUTGRP1[71407]

Please check the Validation Results window for more information

Note the same Mapping is executing in ODI 12.1.3 version successfully without any errors.

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