My Oracle Support Banner

Snapshot Monitor Failing With Error - APP-FND-01564: ORACLE error 1 in mrfxmd_flush_xml_schema_to_db (Doc ID 2832543.1)

Last updated on JANUARY 07, 2022

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version or higher, Memory Based Planner

 

While attempting to run an ASCP plan, Snapshot Monitor request failed.

The following error is observed:


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

..Selecting Calendar 0:00
Unable to flush MSLD_FLAT* files
Error string=
Statement with the error:
insert into msc_flatfile_schema (plan_id,last_update_date,last_updated
APP-FND-01564: ORACLE error 1 in mrfxmd_flush_xml_schema_to_db
Cause: mrfxmd_flush_xml_schema_to_db failed due to ORA-00001: unique constraint (MSC.MSC_FLATFILE_SCHEMA_U1) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Run ASCP Plan.

Nav: Advanced Supply Chain Planner (R)-> Supply Chain Plans -> Launch.


2. See that the Memory Based Snapshot fails with the above error.



Changes

 

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
Changes
Cause
Solution


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