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

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

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 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.

 

Changes

 

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