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