Issues Caused by PA_MAPPABLE_TXNS_TMP_S Sequence Reaching Maximum Value
Last updated on FEBRUARY 10, 2017
Applies to:Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
PA_MAPPABLE_TXNS_TMP_S, Sequence, Budget, Baseline, 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 38202184
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.
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