My Oracle Support Banner

MSCNSWWS64 Memory Based Snapshot Worker 64 Bit Sun Errors ORA-01455 Mrsngs_snp_gross_rqmts (Doc ID 1545698.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 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


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!

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