ODI 12c Mapping Error "ORA-00904: <TABLE ALIAS>.<COLUMN ALIAS>: invalid identifier"
(Doc ID 2415636.1)
Last updated on AUGUST 17, 2020
Applies to:Oracle Data Integrator - Version 18.104.22.168.6 to 22.214.171.124.0 [Release 12c]
Information in this document applies to any platform.
After upgrading an Oracle Data Integrator (ODI) 11g Integration Interface to 12c mapping, the generated code contains an incorrect reference to <TABLE ALIAS>. When it is executed, the following error occurs:
The generated code is similar to the following:
Note the <TABLE ALIAS> table alias is different than the one used for the sub-query, which in the example is <SOME TABLE ALIAS>. It is expected to be <TABLE ALIAS>.
You may experience similar issues with incorrect table alias generation, with differing results and error messages depending on the code generated. The issue remains the same.
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