ORA-12034 Error In BIS_MV_REFRESH When Running SCI Request Set (Doc ID 1985427.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Supply Chain Intelligence - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.2 version, Daily Business Intelligence

When attempting to run our Initial Load Request set,
the following error occurs.

ERROR
-----------------------
BIS_MV_REFRESH module: BIS Materialized View Refresh Program


ORA-12034: materialized view log on "APPS"."ENI_RES_5_MV" younger than last refresh
Start refreshing for OPI_DBI_RES_UTL_MV, mode INIT
MV compile state : VALID.
Performing Initial loading
DB Version: 11.2.0.3.0
Atomic refresh: false
OPI_DBI_RES_UTL_MV was altered to parallel

Error occurred:
ORA-12034: materialized view log on "APPS"."ENI_RES_5_MV" younger than last refresh


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the request set
2. Note the error above

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