ODI Mapping Error 'ORA-00904: "TABLE_ALIAS"."COLUMN": invalid identifier'
(Doc ID 2415636.1)
Last updated on JULY 10, 2018
Applies to:Oracle Data Integrator - Version 22.214.171.124.6 to 126.96.36.199.0 [Release 12c]
Information in this document applies to any platform.
After upgrading an Oracle Data Integrator (ODI) 11g mapping to 12c, the generated code contains an incorrect reference to TABLE_ALIAS. When it is executed, the following error occurs:
The generated code will be similar to the following:
Note the INVENTORY_ITEM_ID table alias is different than the one used for the subquery, which in the example is SOME_REF. It is expected it would 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!