PAXACMPT PRC: Update Project Summary Amounts Errors With ORA-04030 (Doc ID 1355101.1)

Last updated on SEPTEMBER 11, 2016

Applies to:

Oracle Project Planning and Control - Version 11.5.10.2 and later
Information in this document applies to any platform.
Report:PAXACMPT.RDF - PRC: Update Project Summary Amounts
ConcurrentProgram:PAXACMPT_SINGLE - PRC: Update Project Summary Amounts for a Single Project

***Checked for relevance on 15-SEP-2014***


Symptoms

When the customer is running the PAXACMPT for all projects a ORA-04030 is generated.

+---------------------------------------------------------------------------+
PAXACMPT module: PRC: Update Project Summary Amounts
+---------------------------------------------------------------------------+
Current system time is 23-AUG-2011 23:07:21
+---------------------------------------------------------------------------+

+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
p_actual_cost_flag='Y'
p_revenue_flag='Y'
p_budgets_flag='Y'
p_commitment_flag='Y'
p_debug_mode='N'
P_SUMM_CONTEXT='REGULAR'
P_DELETE_TMP_TABLE='N'
P_GEN_REP='N'
p_mode='I'
------------

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.US7ASCII

'.,'

MSG-00001: Calling Maintain Project Accumulation at 23-AUG-2011 23:07:23
MSG-00001: Concurrent request id is 12013579
MSG-00001: ORA-04030: out of process memory when trying to allocate 47640 bytes (QERHJ hash-joi,kllcqc:kllcqslt)
MSG-00001: Debug Messages:
MSG-00001: proj_accum: **** PLEASE REFRESH THE PROJECT 006900-00000-99 ****
MSG-00001: proj_accum: ****** PROJECT IS CLOSED AND NOT ELIGIBLE FOR ACCUMULATION *******
MSG-00001: proj_accum: **** PLEASE REFRESH THE PROJECT 007000-00000-99 ****
.
.(similar errors with the MSG-00001 in middle of the log)
.
.
MSG-00001: proj_accum: ****** PROJECT IS CLOSED AND NOT ELIGIBLE FOR ACCUMULATION *******
MSG-00001: proj_accum: **** PLEASE REFRESH THE PROJECT 991179-00000-08 ****
MSG-00001: proj_accum: ****** PROJECT IS CLOSED AND NOT ELIGIBLE FOR ACCUMULATION *******
MSG-00001: proj_accum: Exception Generated By Oracle Error: ORA-04030: out of process memory when trying to allocate 47640 bytes (QERHJ hash-joi,kllcqc:kllcqslt)
MSG-00001: Exception was generated by Accumulation API
REP-1419: 'beforereport': PL/SQL program aborted.

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