Problem With Calculation Of Next Available USER_DATA_CATEGORY_VALUE_ID Value (Doc ID 1931416.1)

Last updated on FEBRUARY 22, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

There is a problem with the how the next available ASAP.USER_DATA_CATEGORY_VALUES.USER_DATA_CATEGORY_VALUE_ID value is calculated which causes it to grow very rapidly.



STEPS

The issue can be reproduced at will with the following steps:

1. Create a User Data Category of list CITY_STATE with 5 Display Values

2. Run the SQL below and note the USER_DATA_CATEGORY_VALUE_ID value


5. Repeat step 3 and 4 numerous times and observe the pattern


BUSINESS IMPACT

Due to this issue, the next available value could exceed the ASAP.USER_DATA_CATEGORY_VALUES.USER_DATA_CATEGORY_VALUE_ID column definition of NUMBER(9,0).

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