ODI errors ORA-00904 invalid column name

ORA-00904 invalid column name

1) Keying error in a mapping/join/filter. A string which is not a column name is interpreted as a column name, or a column name is misspelled.

 2) This error may also appear when accessing an error table associated to a datastore with a recently modified structure. It is necessary to impact in the error table the modification, or drop the error tables and let Oracle Data Integrator recreate it in the next execution.

Solution:

1) Check the Column names in Filter or Join Condition Editor, It should not contain column name with "".

2) Update E$table using CKM Options like Drop temporary table is True or Update Error Table is True.