My Oracle Support Banner

Issues Caused by PA_MAPPABLE_TXNS_TMP_S Sequence Reaching Maximum Value (Doc ID 2231996.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
PA_MAPPABLE_TXNS_TMP_S, PRC: Update Project Summary Amounts

Symptoms

When sequence PA_MAPPABLE_TXNS_TMP_S reaches its maximum value, it can cause issues with concurrent programs and project budget baseline failing, including in the form of performance issues with Budget Workflow.

E.g. PRC: Update Project Summary Amounts is completing in error for all OU's:

MSG-00001: Calling Refresh Project Accumulation
MSG-00001: Concurrent request id is 1234567
MSG-00001: ORA-08004: sequence PA_MAPPABLE_TXNS_TMP_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
MSG-00001: Exception was generated by Accumulation API
REP-1419: 'beforereport': PL/SQL program aborted.

 

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
Cause
Solution
References


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