"Invalid object name" Error when Executing in ODI 12c Mappings Upgraded from ODI 11g
Last updated on DECEMBER 14, 2017
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 12c]
Information in this document applies to any platform.
After upgrading from Oracle Data Integrator (ODI) 11g to 188.8.131.52.6, some Mappings fail to execute.
These Mappings contain SQL sub-queries based on the target table.
The execution fails with the error below:
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