My Oracle Support Banner

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

Last updated on MARCH 29, 2019

Applies to:

Oracle Materials Requirement Planning - Version 12.0 and later
Information in this document applies to any platform.

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

STEPS
-----------------------
1. MRP Responsibility
2. Nav: MRP - Launch Plan
Run MRP plan
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


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