Memory-Based Snapshot Worker Error With ORA-01455 Converting Column Overflows Integer Datatype
(Doc ID 1419591.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Materials Requirement Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Materials Requirements Plan.
When attempting to run a regular MRP plan, MRCNSW errors with the following:
APP-FND-01564: ORACLE error 1455 in mrsnpo_snp_po_info
Cause: mrsnpo_snp_po_info failed due to ORA-01455: converting column overflows integer datatype
.
The SQL statement being executed at the time of the error was: select mrp_item_purchase_orders_s.nextval into :b0 from dual ganizat and was executed from the file .
APP-MRP-22075: An internal error has occurred (mrnspxt, 18, 10006, )
ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10006, )
ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (main, 13, , )
ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
thsk1=1
gthsk2=1
gthsk3=1
gthsk4=1
Statement with the error:
select mrp_item_purchase_orders_s.nextval into :b0 from dual ganizat
SQL Error Code: -1455
-----------------------
The issue can be reproduced at will with the following steps:
1. MRP Responsibility
Plan fails with ORA-01455 in MRCNSW
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |