MRCNSP module: Memory-Based Snapshot Completes With Errors APP-FND-01564 ORA-12801 ORA-12853 ORA-04031
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