ODI Main Package Fails INT-LOAD_FACT_CONTENT_STG_B Violating Unique Key Constraint

(Doc ID 2416410.1)

Last updated on JUNE 27, 2018

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.

Symptoms

Then error emails are being generated but no errors are being produced in the package steps.
These error emails are.
ODI_SESSION_NO,ODI_SCENARIO_NAME,ODI_INTERFACE_NAME,ODI_ERROR_CNT
-----------------------------------------------------------------
151100,PKG_LOAD_DIM_STG_TABLES,INT-Load_DIM_RESPONSES,344

A procedure was given to create an error table for these records and save the records.
Showing some records.
ODI_ERR_TYPE ODI_ERR_MESS ODI_CHECK_DATE RESPONSES_KEY NAME TYPE PURPOSE URL DATE_CREATED TENANT_ID DATE_UPDATED DATE_INSERTED DOC_ID ODI_ORIGIN ODI_CONS_NAME ODI_CONS_TYPE ODI_ERR_FLAG ODI_SESS_NO
F ODI-15063: The alternate key UNIQUE_KEY is not unique. 12-SEP-17 OSCAR Screen Field Definition - Claim Number/Message Unstructured 4 https://kmtest.com/infocenter/index?page=content&id=GLS5780&actp=search&viewlocale=en_US 09-SEP-17 12-SEP-17 (1801)DW_Data_Loads.INT-LOAD_DIM_RESPONSES UNIQUE_KEY AK N 37080100
F ODI-15063: The alternate key UNIQUE_KEY is not unique. 12-SEP-17 OSCAR Screen Field Definition - Medicare Claim Number Unstructured 4 https://kmtest.com/infocenter/index?page=content&id=GLS5554&actp=search&viewlocale=en_US 09-SEP-17 12-SEP-17 (1801)DW_Data_Loads.INT-LOAD_DIM_RESPONSES UNIQUE_KEY AK N 37080100
F ODI-15063: The alternate key UNIQUE_KEY is not unique. 12-SEP-17 OSCAR Screen Field Definition - Medicare Claim Number Unstructured 0 https://kmtest.com/infocenter/index?page=content&id=GLS5554&actp=search&viewlocale=en_US 09-SEP-17 12-SEP-17 (1801)DW_Data_Loads.INT-LOAD_DIM_RESPONSES UNIQUE_KEY AK N 37080100

For the same question and response after faceting there are two purposes:
OSCAR Screen Field Definition -  Blue Shield Claim Facility
Adjustment Request Claim Link
Number Unstructured 4 https://kmtest.com/infocenter/index?page=content&id=GLS4826&actp=search&viewlocale=en_US 09-SEP-17 12-SEP-17
OSCAR Screen Field Definition - Blue Shield Claim Facility
Adjustment Request Claim Link
Number Unstructured 0 https://kmtest.com/infocenter/index?page=content&id=GLS4826&actp=search&viewlocale=en_US 09-SEP-17 12-SEP-17

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