Determining the Current Values of the ODI Repository Internal IDs (Doc ID 763428.1)

Last updated on MAY 10, 2021

Applies to:

Purpose

The purpose of this document is to provide a complete list of Oracle Data Integrator (ODI) Master and Work Repository internal IDs having been ever used to develop or import ODI Objects into the current environment.

Note that if incorrect internal IDs are used:

• The import of Master and/or Work Repository Objects will fail
• New Objects may not be created

Due to violation of a Primary Key constraint.

For example, during the "mimport" of a Master Repository, a violation of FK_MTXT may be thrown.

Troubleshooting Steps

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