Problem With Calculation Of Next Available USER_DATA_CATEGORY_VALUE_ID Value
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.
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).
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