FK_TXT_CROSSR_UFUN Violation is Received Upon Smart Import of User Functions Into an ODI 12.2.1.2.6 Repository

(Doc ID 2382022.1)

Last updated on APRIL 16, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 to 12.2.1.2.6 [Release 12c]
Information in this document applies to any platform.

Symptoms

With a smart export file generated from Oracle Data Integrator (ODI) 11g, and which contains global User Functions, the smart import into an ODI 12.2.1.2.6 Repository fails with following error:

com.sunopsis.dwg.SQLWorkReposException: ORA-02291: integrity constraint (ODI12c_COMPAT_REPO.FK_TXT_CROSSR_UFUN) violated - parent key not found

Note that the ODI 12c Repository has 11g-compatibility mode turned OFF, which is default when creating a Repository in ODI 12c.

Changes

 

Cause

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 hundreds of Community platforms