My Oracle Support Banner

MRCNSP - Memory Based Snapshot Fails Intermittently With ORA-01455 (Doc ID 1071827.1)

Last updated on OCTOBER 23, 2019

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 26-Apr-2012***
Executable:MRCNSP - Memory-based Snapshot
ConcurrentProgram:MRCNSW - Memory-based Snapshot Worker


Goal

Users are finding an intermittent issue when running a DRP/MPS/MRP plan.  Either Memory Based Snapshot - MRCNSP - or Memory Based Snapshot Worker - MRCNSW - fails with the following:

APP-FND-01564: ORACLE error 1455 in mrllpi_load_planned_items

Cause: mrllpi_load_planned_items failed due to ORA-01455: converting column overflows integer datatype

The SQL statement being executed at the time of the error was: select /*+ PARALLEL (items) +*/ items.inventory_item_id ,items.orga and was executed from the file 7195985/mrp/lib/mrlsii.pc.
APP-MRP-22075: An internal error has occurred (main, 10, 356, MRPPlan)
gthsk1=42963
gthsk2=9
gthsk3=1
gthsk4=1

Statement with the error:
select /*+ PARALLEL (items) +*/ items.inventory_item_id ,items.orga
7195985/mrp/lib/mrlsii.pc"

Upon rerunning the plan after the failure, it completes successfully.  Is there any known cause that can help fix this problem?

Solution

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
Goal
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.