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 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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.