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.


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:


..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

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.




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

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