My Oracle Support Banner

WMS Sequence WMS_TRANSACTIONS_TEMP_S Is About To Exceed Its Maximum Value: ORA-08004: sequence WMS_TRANSACTIONS_TEMP_S.NEXTVAL exceeds MAXVALUE (Doc ID 2673472.1)

Last updated on MARCH 13, 2023

Applies to:

Oracle Warehouse Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

The WMS Sequence WMS_TRANSACTIONS_TEMP_S is about to exceed its maximum value.

For example:
SEQUENCE_NAME: WMS_TRANSACTIONS_TEMP_S
MAX_VALUE: 2147483647
LAST_NUMBER: 1932736708

Log error
ORA-08004: sequence WMS_TRANSACTIONS_TEMP_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated in Package WMS_Engine_PVT Procedure insert_detail_temp_records

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


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