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.

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


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. 


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