My Oracle Support Banner

UDA Values Creation Error When UDA Data Type Is Number & Uda Value Desc Includes Zeroes (Doc ID 2941508.1)

Last updated on APRIL 12, 2023

Applies to:

Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.


When new UDA values are created using data upload in RMS under an uda for which data type is 'Number', error stating - 'Field contains non-numeric character'
is encountered. We could see that the UDA values are getting created without any issues if the UDA_VALUE_DESC does not include any zeroes. However, when the description includes zeroes the error is encountered.

Field contains non-numeric character.

Create a UDA and UDA values via upload with following parameters -
UDA sheet -
1. Action - Create
2. UDA - 1
3. Display type - List of Values
4. Data type - Number
UDA values sheet
1. Action - Create
2. UDA - 1
3. UDA Value - 10
4. UDA Value Description - 10 


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

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