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 later
Information in this document applies to any platform.
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:
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.
Advanced supply chain planner
1. Run Collections
2. Run ASCP plan
3. Plan fails
Customer manipulated source sequence MRP_SCHEDULE_DATES_S to use values > 2,147,483,647
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