Cost Manager Error cmlwcm failed due to ORA-08004: sequence WIP_TRANSACTIONS_S.NEXTVAL (Doc ID 1996784.1)

Last updated on MAY 21, 2015

Applies to:

Oracle Cost Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
With Cost Management Responsibility
Run request: Cost Manager.

Symptoms

Cost Manager Errored out with Below Error:

 

Changes


for 
SEQUENCE_NAME
WIP_TRANSACTIONS_S

LAST_NUMBER
4,294,967,296
is higher than 
MAX_VALUE
4,294,967,295

 

There are 5 tables that use this sequence:

wip_transaction_accounts

wip_transactions
wip_move_transactions
wip_cost_txn_interface
wip_move_txn_interface

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