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.

Symptoms

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

Error

=====

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

 

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