My Oracle Support Banner

Bad Performance with Standard Reverse-Engineering of EBS Custom Table in ODI 12c (Doc ID 2968072.1)

Last updated on AUGUST 17, 2023

Applies to:

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

Symptoms

After an upgrade of Oracle Data Integrator (ODI) to 12.2.1.4+, reverse-engineering of Oracle E-Business Suite Applications (EBS) custom tables are much longer than in 11g. Note that EBS was also upgraded, and schemas are now edition-enabled.
Reverse-engineering of "synonyms" is quick.
However, using the same connection information, reverse-engineering of tables may take about 20 minutes, where in 11g the same table is reverse-engineered within two or three minutes.

Changes

 

Cause

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.