"(ODI_10143: Error while accessing the ODI repository. ORA-02292: integrity constraint (XX.FK_MAP_EXPR_REF) violated -child record found" Signaled When Saving Of Complex Mapping in ODI 12.1.3 (Doc ID 2020982.1)

Last updated on MAY 12, 2017

Applies to:

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

Symptoms

While saving a complex mapping in ODI 12.1.3 after modifying it by deleting a join or renaming a component etc, the below errors are signalled:

 

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