My Oracle Support Banner

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

Last updated on JANUARY 05, 2021

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

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.