My Oracle Support Banner

MRCNSP module: Memory-Based Snapshot Completes With Errors APP-FND-01564 ORA-12801 ORA-12853 ORA-04031 (Doc ID 2125334.1)

Last updated on MARCH 16, 2020

Applies to:

Oracle Materials Requirement Planning - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

MRCNSP module: Memory-based Snapshot is completing in error

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, <server name> instance <instance name> (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 .


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

Cause

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
Symptoms
Cause
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.