Sequence CST_COGS_EVENTS_S Nearing Max Value (Doc ID 2482122.1)

Last updated on MARCH 06, 2019

Applies to:

Symptoms

On : 12.1.3 version, Setup Issues

ACTUAL BEHAVIOR
---------------
CST_COGS_EVENTS_S nearing max value

In database, sequence BOM.CST_COGS_EVENTS_S is nearing the maximum value. What are the options?

In file cstrcmo.odf in $BOM_TOP
# Sequence Name CST_COGS_EVENTS_S
# Application Id, Sequence Id
702 21259
# Sequence Sequence
50

# Min Value, Max Value,    Increment By
1               2147483647    1

# Object Name
CST_COGS_EVENTS_S
# select, insert, delete, update; reference, alter, index; grant option
Y N N N N N N N


EXPECTED BEHAVIOR
-----------------------
Expect to expand Max VALUE

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
review BOM.CST_COGS_EVENTS_S

Cause

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