How Do the Values of the Internal IDs of ODI 10g and 11g Master and Work Repositories Impact Object Identifiers and Export-Import Procedures (Doc ID 786341.1)

Last updated on MAY 10, 2021

Applies to:

Purpose

Oracle Data Integrator (ODI) Master and Work Repositories are identified by their unique internal ID, a numeric value between 0 and 999.

The internal IDs are also used to compute the Primary Key of records stored in ODI Repository tables.

1. How does the Master/Work Repository internal ID impact developments?
2. How to decide which values may be be used?

Scope

This document is intended to those users that wish to:

1. Understand how Primary Keys are computed by Oracle Data Integrator (ODI).
2. Correctly handle Development, Integration... Production environments when the deployment is performed with ODI export - import operations.

Details

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