MSCNSWWS64 Memory Based Snapshot Worker 64 Bit Sun Errors ORA-01455 Mrsngs_snp_gross_rqmts
(Doc ID 1545698.1)
Last updated on JULY 02, 2021
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.0 and laterInformation in this document applies to any platform.
Symptoms
A very similar error is occurring in the Planning Manager and the Memory Based Snapshot Worker that has the same cause and can be resolved in the same way:
Error
=====
Memory Based Snapshoht
check SQLCODE = -1455APP-FND-01564: ORACLE error 1455 in mrsngs_snp_gross_rqmts
Cause: mrsngs_snp_gross_rqmts failed due to ORA-01455: converting column overflows integer datatype
Planning Manager / MRP_RELIEF_INTERFACE
Cause: forward failed due to ORA-01455: converting column overflows integer datatype
The SQL statement being executed at the time of the error was: select TO_CHAR(dates.schedule_date,'J') ,NVL(TO_CHAR(dates.
STEPS
=====
Advanced supply chain planner
1. Run Collections
2. Run ASCP plan
3. Plan fails
Changes
Customer manipulated source sequence MRP_SCHEDULE_DATES_S to use values > 2,147,483,647
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 |
References |