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:
Oracle Procurement Intelligence - Version 12.1.2 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |