Load/Copy/Merge MDS Concurrent Request Selects Millions of Sales Order Records and Completes with Signal 10 Error (Doc ID 1472743.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 14-May-2014***

Symptoms

On :  12.1.2 version, Master Demand Schedule

When attempting to run Load/Copy/Merge MDS concurrent request ,
the program is not considering the parameter "Sales Orders From Start Date Forward" (Argument 7 (SALES_CODE) = 3)
and selects over 3 million sales orders.  This is causing the program to fail with memory issues such as:

ERROR
-----------------------
.Loading sales orders                                           3,178,76    4:11
memi_so_demand: Cannot allocate memory for new_block->block

OR

kgefec: fatal error 0
OCI-21503: program terminated by fatal error
OCI-04030: out of process memory when trying to allocate 1104 bytes (Alloc environm,alloc statement hndl)
Errors in file :
OCI-21503: program terminated by fatal error
OCI-04030: out of process memory when trying to allocate 1104 bytes (Alloc environm,alloc statement hndl)
.
.
.
----- End of Call Stack Trace -----

/v04/app/applprd/apps/apps_st/appl/mrp/12.0.0/bin/MRCSAL
Program was terminated by signal 10

Cause

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