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


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)

Statement with the error:
select /*+ PARALLEL (items) +*/ items.inventory_item_id ,items.orga

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


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

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