VOLUME RULE EVALUATES INCORRECTLY DUE TO ROUNDING PROBLEM (Doc ID 2120053.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Fusion Product Hub - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Import Items

1. Create a rule and save. The Gross Weight attribute has a format validation value set linked as “15.3”, meaning 3 decimals are allowed for this attribute.

If expression :
[Item].[Item Basic].[Organization Code] != "MST" and [Item].[Indicator].[Service] == "FALSE"
Validation Condition :
[Item].[Dimension].[Gross Weight] > 0

2. Import an item with weight 0.361kg. Import success

3. Import an item with weight 0.358kg. Import fails

Also if an item with weight 2.248kg is imported, system stores it as 2kg which is incorrect.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Incorrect volume of product is accepted as a result

Cause

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