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 MARCH 08, 2017

Applies to:

Oracle Grants Accounting - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Refresh Transaction Summary Amounts requests  completes in Error

PAXACRTA module: PRC: Refresh Transaction Summary Amounts
+---------------------------------------------------------------------------+
MSG-00001: Concurrent request id is 78743305
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 137
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 78743305
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 78743305.

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.

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