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

Last updated on MARCH 15, 2022

Applies to:

Symptoms

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

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