My Oracle Support Banner

Wrong Default Number Attribute Value Is Set Via Constraint (Doc ID 2053495.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel CRM - Version 15.3 [IP2015] and later
Information in this document applies to any platform.


Siebel version:- 15.3 [IP2015]
Platform:- Oracle Solaris on SPARC (64-bit)

Statement of Issue:
Adding a constraint based on a product attribute of Data Type: Number and Domain Type: FreeForm and select validate produces a floating point number which is incorrect. So 2 becomes 2.00000000001821

Value displayed in configurator is incorrect 2.00000000001821 instead of 2.

Created a product attribute via Administration - Product ->Attribute Definitions -> Version
Data Type: Number
Domain Type: FreeForm
Release version
Create a product class “New Class” and add the attribute above to it. Administration - Product ->Product Class [New Class] -> Workspace. Release it and update cache
Create a new product under Administration - Product -> Product Definitions
Under workspace select constraints from the Product Designer view.
Choose the constraint template and continue
Choose Compound logic functions “AND” [pick]

Select the link ” item or condition” in the Rule statement then the button marked Condition in the images below. In the popup window labelled Templates select the item in the list marked “Attribute Value” an hit the Pick button. Then click the “Item attribute” image in the popup select the Test Attribute.

Click the image button “Comparison operator” select from the popup the “>=” operator and click the pick button.

Select the number image button and in the popup enter a number

Select the second link in the Rule Statement labelled item or condition and run through the above steps again this time the math operator is <= and select the number.

Now save the constraint using the Save Constraint button near the Rule statement

Then select validate from the menu and you will see the unusual value. 




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.