My Oracle Support Banner

'Synonym Mode UPDATE' and 'Synonym Mode INSERT_UPDATE' Missing from the ODI Import Options (Doc ID 2328803.1)

Last updated on APRIL 11, 2023

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


When attempting to import an interface object into an Oracle Data Integrator (ODI) repository using Studio, there are no 'Synonym Mode UPDATE' or 'Synonym Mode INSERT_UPDATE' selections available. These options existed in previous ODI 11g versions and later ODI 12c versions when importing mappings.

This can be replicated by right-clicking the Interfaces node in a project and selecting 'Import Interface...' It is expected that the two highlighted options would be available, however, they are not in the drop-down list.


This behavior may be discovered if ODI was upgraded from a previous version where the import mode options are available.


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.