MRCNSP module: Memory-Based Snapshot Completes With Errors APP-FND-01564 ORA-12801 ORA-12853 ORA-04031
(Doc ID 2125334.1)
Last updated on NOVEMBER 04, 2018
Applies to:Oracle Materials Requirement Planning - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Materials Requirements Plan.
MRCNSP module: Memory-based Snapshot is completing in error
APP-FND-01564: ORACLE error 12801 in mrllpi_load_planned_items
Cause: mrllpi_load_planned_items failed due to ORA-12801: error signaled in parallel query server P069, instance dm01dbadm01:scmprd1 (1)
ORA-12853: insufficient memory for PX buffers: current 350176K, max needed 392832K
ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown .
The issue can be reproduced at will with the following steps:
1. Advanced Supply Chain Planner -> Supply Chain Plan -> Launch
2. The "Launch Supply Chain Planning Processes" request set starts
3. MRCNSP module: Memory-based Snapshot completes in error
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|