ODI Mapping Error 'ORA-00904: "TABLE_ALIAS"."COLUMN": invalid identifier'
Last updated on JULY 10, 2018
Applies to:Oracle Data Integrator - Version 220.127.116.11.6 to 18.104.22.168.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms