Updating ODI Object With Legacy Import Using "Synonym UPDATE" Seems to Work But There is no Actual Modification

(Doc ID 2248830.1)

Last updated on APRIL 05, 2017

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.




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