BIS Materialized View Refresh Program Erroring On POA_PQC_BS_MV (Doc ID 2148448.1)

Last updated on JUNE 27, 2016

Applies to:

Oracle Procurement Intelligence - Version 12.1.2 and later
Information 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:
-----------------------
BIS_MV_REFRESH module: BIS Materialized View Refresh Program
+---------------------------------------------------------------------------+

Current system time is 16-MAR-2016 17:14:25

+---------------------------------------------------------------------------+

**Starts**16-MAR-2016 17:14:25
**Ends**16-MAR-2016 17:14:38
ORA-12034: materialized view log on "APPS"."POA_PQC_BS_J2_MV" younger than last refresh
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Start refreshing for POA_PQC_BS_MV, mode INIT
MV compile state : VALID.
Performing Initial loading
DB Version: 11.2.0.3.0
Atomic refresh: false
POA_PQC_BS_MV was altered to parallel

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

Steps to reproduce:
1. Run the DBI requests
2. Run the request "BIS Materialized View Refresh Program" with clear and load
3. See the error

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