My Oracle Support Banner

Mapping Executes on Incorrect Schema After Upgrade from ODI 11g to ODI 12c (Doc ID 2577488.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


After upgrading Oracle Data Integrator (ODI) to, an interface/mapping fails with the following exception:

11g Code (executes as expected):

create synonym <work_schema_TARGET>.C$<table_unique_name>
for <work_schema_SOURCE>.C$<table_unique_name>@<DBLINK>

12c code (executes with the above error):

create synonym <work_schema_SOURCE>.C$_<table_unique_name>
for <work_schema_SOURCE>.C$_<table_unique_name>@<DBLINK>



 Upgrade from to


To view full details, 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 a vibrant support community of peers and Oracle experts.