Memory-Based Snapshot Worker Error With ORA-01455 Converting Column Overflows Integer Datatype (Doc ID 1419591.1)

Last updated on JULY 03, 2024

Applies to:

Symptoms

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

Cause

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