Using Same Variable In Both Mapping And Reusable Mapping Causes Execution Of The ODI Main Mapping To Fail With "ODI-10143: Error while accessing the ODI repository And ORA-00001: unique constraint (DEV1_ODI12C_REPO.PK_VAR_SB) violated" Message
Last updated on MAY 09, 2017
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 to 22.214.171.124.1 [Release 12c]
Information in this document applies to any platform.
Having a situation where the same Variable is used in both an Oracle Data Integrator (ODI) Mapping, and Reuseable Mapping.
After having added the Reusuable Mapping to the main Mapping, the execution of the main Mapping fails with:
ORA-00001: unique constraint (PK_VAR_SB) violated
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