MSCNSWWS64 Memory Based Snapshot Worker 64 Bit Sun Errors ORA-01455 Mrsngs_snp_gross_rqmts
Last updated on FEBRUARY 02, 2018
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 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
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.
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
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms