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 126.96.36.199.201011 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) 188.8.131.52, 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