Refresh Project Summary Amounts Request Ends In Error

(Doc ID 1611328.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

When trying to run the PRC: Refresh Project Summary Amounts it ends in Error Status.

Enter Password:=20
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:=20
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

Report Builder: Release 10.1.2.3.0 - Production on Wed Oct 23 09:30:57 =
2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.


+------------------------------------------------------------------------=
---+
Start of log messages from FND_FILE
+------------------------------------------------------------------------=
---+
+------------------------------------------------------------------------=
---+
End of log messages from FND_FILE
+------------------------------------------------------------------------=
---+
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.

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