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 AUGUST 31, 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.


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!

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