OBIA 11g : PLP_CustomerStatusHistoryFact_Status_Revalidate.W_CUSTOMER_STATUS_HIST_F Fails After 1 Attempt (Doc ID 1615091.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

While running the load plan for the first time the interface PLP_CustomerStatusHistoryFact_Status_Revalidate.W_CUSTOMER_STATUS_HIST_F
has failed with below error:

Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_DW.W_CST_STTHST_F_U1) violated

No duplicate records exist on these source side.

Below is an extract from the log file:

Folder - PLP_CustomerStatusHistoryFact_Status_Revalidate
Interface Name - PLP_CustomerStatusHistoryFact_Status_Revalidate.W_CUSTOMER_STATUS_HIST_F
Target Table - W_CUSTOMER_STATUS_HIST_F

Error Msg -
-----------
[CDATA[ODI-1217: Session PLP_PLP_CUSTOMERSTATUSHISTORYFACT_STATUS_REVALIDATE (15555500) fails with return code 1.
ODI-1226: Step PLP_CustomerStatusHistoryFact_Status_Revalidate.W_CUSTOMER_STATUS_HIST_F fails after 1 attempt(s).
ODI-1240: Flow PLP_CustomerStatusHistoryFact_Status_Revalidate.W_CUSTOMER_STATUS_HIST_F fails while performing a Integration operation. This flow loads target table W_CUSTOMER_STATUS_HIST_F.
ODI-1228: Task PLP_CustomerStatusHistoryFact_Status_Revalidate.W_CUSTOMER_STATUS_HIST_F (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_DW.W_CST_STTHST_F_U1) violated

 

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