Snapshot Monitor Is Erroring Out With APP-FND-01564: ORACLE Error 1455 In msc_flush_flatfiles_snpsd
(Doc ID 2986849.1)
Last updated on NOVEMBER 20, 2023
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
Snapshot Monitor is erroring out with APP-FND-01564: ORACLE error 1455 in msc_flush_flatfiles_snpsd
mbp flat file dir /EBSPROD_shared/csf/out/data21/
Use AQ to do inter process communications
DELETE /*+ CHOOSE */ FROM msc_snapshot_tasks
AND rownum <= 25000
AND -1 = -1.Deleted from msc_snapshot_tasks 79 0:00
CONCURRENT MSC MSCSDW "PLAN_ID=21" "SNAP_STATIC_ENTITIES=1" "SNAPSHOT_MODE=1" "MON_REQUEST_ID=240840221"
Launched concurrent request 240840225 for workers
Unable to flush MSLD_FLAT* files
Statement with the error:
select msc_supplies_s.nextval ,msc_available_to_promise_s.nextval ,m
APP-FND-01564: ORACLE error 1455 in msc_flush_flatfiles_snp
Cause: msc_flush_flatfiles_snp failed due to ORA-01455: converting column overflows integer datatype
The SQL statement being executed at the time of the error was: select msc_supplies_s.nextval ,msc_available_to_promise_s.nextval ,m and was executed from the file .
The issue can be reproduced at will with the following steps:
1. Navigation: Advanced Supply Chain Planner > Supply Chain Plan > Launch
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