ORA-00001: UNIQUE-key violation (ODI_ODI_REPO.PK_SNP_MISSING_REF)

While Importing objects from One Work Repository to Another Work Repository in ODI 12c 12.1.2
Version  We can get these below common error.

ORA-00001: UNIQUE-key violation (ODI_ODI_REPO.PK_SNP_MISSING_REF).

or 

com.sunopsis.core.SnpsDuplicateAKException: ODI-10035: SNP_SCEN : 'IMPORT_TEST Version 001'


Solution:

  Apply patch 17836908   for resolving above issues OR

12.1.3 version this issue fixed.

Note:  While exporting select with it child components and While importing
select INSERT_UPDATE mode for if objects are already exist it will update and if does not exists it will insert.

Missing References Error  while import Work Repository Objects or Default its creating Yellow interfaces due to not able to map target tables.

In order to avoid missing references, use either the Smart Export and Import feature or solutions to manage dependencies.