ORA-12034: Materialized View Log On "APPS"."POA_PQC_BS_J_MV" Younger Than Last Refresh (Doc ID 1558353.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Procurement 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 the daily business intelligence clear request for procurement requests,
the following error occurs.

ERROR
-----------------------
ORA-12034: materialized view log on "APPS"."POA_PQC_BS_J_MV" younger than last refresh
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Start refreshing for POA_BM_ITEM_O_MV, mode INIT
MV compile state : VALID.
Performing Initial loading
DB Version: 11.2.0.2.0
Atomic refresh: false
POA_BM_ITEM_O_MV was altered to parallel

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the DBI requests

2.  Run the request with clear and load



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