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 12.2.1.3.190415 to 12.2.1.4.200413 [Release 12c]Information in this document applies to any platform.
Symptoms
An Oracle Data Integrator (ODI) environment has been upgraded from 11.1.1.9 to 12.2.1.3.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:
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 |