Planning Data Pull Worker Fails With Ora-04030 (Doc ID 1268629.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for relevance on 26-JUN-2013 MSCPDPW
ORA-04030

Symptoms

Planning Data Pull Worker completes with error when running a full data collection.

Procedure LOAD_HARD_RESERVATION started.
Error pulling data from MRP_AP_HARD_RESERVATIONS_V to MSC_ST_RESERVATIONS.
ORA-04030: out of process memory when trying to allocate 16776728 bytes (QERHJ hash-joi,QERHJ Hash Table Entries)

 

Changes

Installed
<Patch 8671960> - APS COLLECTIONS RUP#32 PATCH FOR 11.5.10 BRANCH

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