My Oracle Support Banner

Foreign Keys Removed from Source Table Are Not Removed from ODI Model After Reverse Engineer (Doc ID 2750297.1)

Last updated on FEBRUARY 10, 2021

Applies to:

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


After performing a simple reverse-engineering of a database table in Oracle Data Integrator (ODI), the foreign keys show up as expected in the ODI model. However, when a foreign key is removed from the table on the database, a second ODI reverse-engineer does not remove the foreign key from the ODI model.

It is expected that the reverse-engineer would update the model to represent the table as it is on the database and remove the foreign key.


This may be experienced after applying <Patch 31588251> to the Studio environment.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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