My Oracle Support Banner

'ORA-00904: Invalid Identifier' Displayed When Running ODI 12.1.3 Mappings Set Up For CDC Processing With Oracle Golden Gate (Doc ID 1968822.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When using Oracle Golden Gate for CDC with ODI version 12.1.3,  each mapping has 2 physical designs, one for full load direct from source, one for delta loads thru journalising via Golden Gate.

At mapping runtime the following error staick is displayed :

Examining the generated code shows clearly that the owner prefix for the JRN_... columns does not follow the naming of the inline views but keeps referring to the original table name.

When experimenting with the alias values in the mapping for the source table shows clearly what is happening in the generated code. More specifically, the journal columns JRN_DATE, JRN_FLAG and JRN_SUBSCRIBER get as prefix, the table's name and not the name of the inline view.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.