My Oracle Support Banner

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

Last updated on MARCH 16, 2020

Applies to:

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


On :  12.1.2 version, Daily Business Intelligence

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

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:
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

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


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

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