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:

Symptoms

Snapshot Monitor is erroring out with APP-FND-01564: ORACLE error 1455 in msc_flush_flatfiles_snpsd
 

ERROR
-----------------------
mbp flat file dir /EBSPROD_shared/csf/out/data21/
Use AQ to do inter process communications

DELETE /*+ CHOOSE */ FROM msc_snapshot_tasks
WHERE plan_id=:plan_id
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
Error string=
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 .


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation: Advanced Supply Chain Planner > Supply Chain Plan > Launch

Changes

Cause

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