My Oracle Support Banner

Updating ODI Object With Legacy Import Using "Synonym UPDATE" Seems to Work But There is no Actual Modification or Some Information Missing (Doc ID 2248830.1)

Last updated on JUNE 16, 2022

Applies to:

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


When importing an Oracle Data Integrator (ODI) object that was modified using legacy import, i.e. a Procedure, the Procedure is not actually modified even though the import log report states that the import was successful and the time stamp in database table changes.

The import mode used was synonym UPDATE.

Further investigation shows that records that were not empty before making the update show the modification, and only empty fields don't show a modification.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.