My Oracle Support Banner

MSCCLRFS : APS Collections Refresh Snapshot Thread Ends With Error ORA-12034: Materialized View Log On INV.MTL_TXN_REQUEST_LINES Younger Than Last Refresh (Doc ID 1579061.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Global Order Promising - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, ATP based on collected data

Error in ATP Data Collection  

We are encountering an error while running ATP Data Collections on Order Management Responsibility.
MSCCLRFS module: APS Collections Refresh Snapshot Thread
+---------------------------------------------------------------------------+

ERROR
-----------------

ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error
ORA-12034: materialized view log on "INV"."MTL_TXN_REQUEST_LINES" younger than last refresh
ORA-06512: at "APPS.MRP_CL_REFRESH_SNAPSHOT", line 2474
ORA-0651
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
21-AUG 12:59:29 : single refresh, fast
21-AUG 12:59:29 : Error in refresh snapshot program : ORA-12034: materialized view log on "INV"."MTL_TXN_REQUEST_LINES" younger than last refresh

21-AUG 12:59:29 : In Procedure: handle_ORA_12034.
21-AUG 12:59:29 : Refreshing Snapshots One By One
21-AUG 12:59:29 : Error refreshing individual snapshot : APPS.MTL_TXN_REQUEST_LINES_SN
21-AUG 12:59:29 : Error : ORA-06502: PL/SQL: numeric or value error
ORA-12034: materialized view log on "INV"."MTL_TXN_REQUEST_LINES" younger than last refresh

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.