An ODI 12c Mapping Fails With 'ORA-00904: "xxxx"."xxxx": invalid identifier' Due to Wrong Datastore Alias Starting From Second Column in a Select (Doc ID 2060132.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI) 12.1.3, a Mapping that uses "LKM Sql to Oracle" generates incorrect Datastore alias from the second column on in the Select statement that selects from the source Datastore:

select
E3304002_1.BSTM3 BSTM3,
E3304002.BS$55BS BS_55BS
from TEST.E3304002@JDE_LINK.xxxx.xxx.BIZ E3304002_1
where (1=1)
and (E3304002_1.BS$55KI = 'E');

The Mapping thus fails with this error:

ODI-1227: Task Load data-LKM SQL to Oracle- fails on the source connection XXX.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "E3304002"."BS$55BS": invalid identifier

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

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