Memory-Based Snapshot Worker Error With ORA-01455 Converting Column Overflows Integer Datatype

(Doc ID 1419591.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12.1.3 and later
Information 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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. MRP Responsibility
2. Nav: MRP - Launch Plan
Run MRP plan
Plan fails with ORA-01455 in MRCNSW


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