My Oracle Support Banner

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

Last updated on DECEMBER 18, 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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.