Unable To Assign Value Greater Than '2147483647' For Number Attribute (Doc ID 2282219.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On : 15.10 [IP2015] version, Order Management


it is throwing error when trying to set number values greater than '2147483647' for an attribute of data type number via Product constraints.
without constraints it is allowing enter the number : 2147483647


ERROR
-----------------------

The below error appears:
[1]Wrong field values or value types detected in field Number.
Please re-enter your field values. If you need additional assistance, please refer to the documentation.(SBL-UIF-00299)[2]
The number '12884901888' resulted in a numeric overflow.
  Valid values are between '-2147483648' and '2147483647'.(SBL-DAT-00476)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create two attributes as below
Attribute 1 :-
Attribute Name = Test Attribute Integer
Data Type = Integer
Domain Type = FreeForm

Attribute 2 :-
Attribute Name = Test Attribute Number
Data Type = Number
Domain Type = FreeForm

2. create class and above created two attributes under class
Class Name = Test Attribute Range

3. Create 2 simple products and one custmoizable product as below
Simple Product 1 :-
Product Name = Test Attribute Child
Product Class = Test Attribute Range

Simple Product 2 :-
Product Name = Test Attribute Child1

Customizable Product :-
Product Name = Test Attribute Root
Structure as below
Relationship 1 :-
Relationship Name = Test Attribute Child
Domain Type = Product
Product = Test Attribute Child
Min Card = 1
Max Card = 999
Def Card = 1

Relationship 2 :-
Relationship Name = Test Attribute Child1
Domain Type = Product
Product = Test Attribute Child1
Min Card =
Max Card = 999
Def Card =

3. Validate the product and try to enter values for number and integer attributes
Integer attribute allow the numbers up to : 999999999
Number attribute allow the number up to : 2147483647

4. Now add constraint as below
Selection of Test Attribute Child1 from Test Attribute Child1 requires the attribute Test Attribute Child >> Test Attribute Range >> Test Attribute Number = 2147483647

5. Again try to validate the product, it will not allow to select child 1 product and it will show in red color
try to enter 2147483647 in number attribute it will show error message saying that max allowed value is : 999999999

Changes

Cause

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