MSCNSWWS64 Memory Based Snapshot Worker 64 Bit Sun Errors ORA-01455 Mrsngs_snp_gross_rqmts

(Doc ID 1545698.1)

Last updated on APRIL 27, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to run an ASCP plan the following error occurs in MSCNSWWS64 module: Memory Based Snapshot Worker 64 bit Sun



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



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


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