MRCNSP module: Memory-Based Snapshot Completes With Errors APP-FND-01564 ORA-12801 ORA-12853 ORA-04031

(Doc ID 2125334.1)

Last updated on JUNE 28, 2017

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


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms