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