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 APRIL 07, 2021
Applies to:
Oracle Process Manufacturing Process Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
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.
Changes
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 |