My Oracle Support Banner

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

Last updated on MARCH 07, 2019

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

Changes

 

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
Changes
Cause
Solution
References


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