ASCP Collections with OPM, Planning Data Pull Worker Fails with: "Error Retrieving Effectivities: ORA-04030: Out Of Process Memory..." (Doc ID 2631435.1)

Last updated on JANUARY 22, 2020

Applies to:

Symptoms

On : 12.1.3 version, Data Collections in Production Instance

When attempting to run complete refresh data collections, Planning Data Pull Worker fails.
the following error occurs.

ERROR
-----------------------

Error retrieving effectivities: ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghu sessi,pmucalm coll)
Effectivity extraction failed
03-DEC 02:15:00 : Error in Routine GMP_BOM_ROUTING_PKG.EXTRACT_EFFECTIVITIES.
03-DEC 02:15:00 : User-Defined Exception
03-DEC 02:15:00 : User-Defined Exception
03-DEC 02:15:00 : Error_Stack...
03-DEC 02:15:00 : ORA-06510: PL/SQL: unhandled user-defined exception

03-DEC 02:15:00 : Error_Backtrace...
03-DEC 02:15:00 : ORA-06512: at "APPS.MSC_CL_PULL", line 6649
ORA-06512: at "APPS.MSC_CL_PULL", line 1696


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter the application.
2. Run ASCP data collections.
3. See that the planning data pull worker fails.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot collect and plan fresh data.

Cause

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