BIS Materialized View Refresh Program Errors With Ora-12008 Oki_time_ent_year_mv_u1 ORA-0001 Unique Constraint Violation (Doc ID 335694.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Contracts Intelligence - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance 29-Mar-2015


Symptoms

Running the BIS Materialized View Refresh Program with parameters INCR, OKI_TIME_ENT_YEAR_MV, gives the following error:

BIS_MV_REFRESH module: BIS Materialized View Refresh Program
....
ORA-12008: error in materialized view refresh path
ORA-00001: unique constraint (APPS.OKI_TIME_ENT_YEAR_MV_U1) violated
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Start refreshing for OKI_TIME_ENT_YEAR_MV, mode INCR
OKI_TIME_ENT_YEAR_MV implemented: Y
MV compile state : VALID.
Got refresh threshold for OKI_TIME_ENT_YEAR_MV:
OKI_TIME_ENT_YEAR_MV is Fast Refreshable!

Performing Fast Refresh for OKI_TIME_ENT_YEAR_MV, mode Incremental Loading
The following error while fast-refreshing OKI_TIME_ENT_YEAR_MV is not ignorable:
ORA-12008: error in materialized view refresh path
ORA-00001: unique constraint (APPS.OKI_TIME_ENT_YEAR_MV_U1) violated

Changes

Applied patchset E-Business Intelligence Family Pack 11i.BIS_PF.E

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