R12: PA: PAXACRTA PRC: Refresh Transaction Summary Amounts Completes in Error PA_COMMITMENT_TXNS_S.NEXTVAL exceeds MAXVALUE (Doc ID 1605003.1)

Last updated on SEPTEMBER 09, 2024

Applies to:

Symptoms

Refresh Transaction Summary Amounts request completes in error with the following in the log file:

PAXACRTA module: PRC: Refresh Transaction Summary Amounts
+---------------------------------------------------------------------------+
MSG-00001: Concurrent request id is 'request_id'
MSG-00001: Calling Refresh Transaction Accumulation
MSG-00001: ORA-08004: sequence PA_COMMITMENT_TXNS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
MSG-00001: Debug Messages:
MSG-00001: build_txn_accum: Exception Generated By Oracle Error: ORA-08004: sequence PA_COMMITMENT_TXNS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
MSG-00001: build_txn_accum: Skipping the accumulation for project 'project_number'
MSG-00001: build_txn_accum: Exception Generated By Oracle Error: ORA-08004: sequence PA_COMMITMENT_TXNS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
In-process job terminated:Terminated with error:
REP-1419: MSG-00001: Concurrent request id is 'request_id'
MSG-00001: Calling Refresh Transaction Accumulation
MSG-00001: ORA-08004: sequence PA_COMMITMENT_TXNS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
MSG-00001: Debug Messages:
MSG-00001: build_txn_accum: Exception Generated By Oracle Error: ORA-08004: sequence PA_COMMITMENT_TXNS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
MSG-00001: build_txn_accum: Skipping the
+---------------------------------------------------------------------------+
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 'request_id'.

Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+

NOTE: Similar errors may also exist in the PRC: Update Project Summary Amounts process.

Changes

Cause

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