Cannot Add a New UDA Value If a '99999' UDA Value Already Exists
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising System - Version 13.2 and later
Information in this document applies to any platform.
In the Oracle Retail Merchandising System (RMS) 13.2.x User Defined Attribute (UDA) window, when the UDA value '99999' exists, the user cannot insert any new records. Instead, the value '#####' will be displayed, and the below error is encountered:
Steps to Reproduce:
- Ensure you have a UDA value with ID 99999 in the UDA_VALUE table.
- Go to the front end and select 'add UDA Value' to that UDA where the 99999 record already exists.
- The record inserted online will display '#####' and you will get the error message above. It is expected that RMS would found the next available UDA value.
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