My Oracle Support Banner

After Standard Import of a Mapping in ODI 12c, the Connection to the Datastore Model is Lost and Marked as "Deleted" (Doc ID 2868637.1)

Last updated on FEBRUARY 07, 2023

Applies to:

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


Duplication mode was used when performing the standard export / import of Oracle Data Integrator (ODI) Models.

As a result, the Globally Unique Object Identifiers (GUIDs) of the Models are different in the original repository and the imported repository.

If the Model has underscores (_) in the name, there are no issues with export / import of mappings that use the model.

If there are dots (.) in the name, using standard import results in the Mapping being unable to associate with the existing Datastore. When opening the mapping, "deleted" is seen next to the Datastore name.

However, if the name of the Datastore is renamed using underscore (_) instead of dots (.) in both repositories prior to export / import, the existing Datastore is associated with the mapping.





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.