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 220.127.116.11.190415 to 18.104.22.168.200413 [Release 12c]
Information in this document applies to any platform.
An Oracle Data Integrator (ODI) environment has been upgraded from 22.214.171.124 to 126.96.36.199.0
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