My Oracle Support Banner

ODI 12c Executions Fail with Error Message "ORA-00904: : invalid identifier" when the Source Datastore of a Mapping Start with a Numeric Value and Generates the c$ Table with an empty List of Columns (Doc ID 2729113.1)

Last updated on APRIL 09, 2021

Applies to:

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


An Oracle Data Integrator (ODI) environment has been upgraded from to

When using a Datastore (File technology) which has alias name starting with a numeric value (For example, Datastore <123>TABLE_SRC) as a source in an Oracle Data Integrator (ODI) 12c Mapping using LKM SQL to Oracle, the execution of the Mapping fails and the following error is received:


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.