Issues Caused by PA_MAPPABLE_TXNS_TMP_S Sequence Reaching Maximum Value
(Doc ID 2231996.1)
Last updated on MARCH 21, 2019
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
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.
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