Issue With Rounding Of Decimals In Case Of UOM Conversion To Calculate Product Quantity (Doc ID 2270788.1)

Last updated on MAY 26, 2017

Applies to:

Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Product Development Formulas

ACTUAL BEHAVIOR
---------------
Issue with the UOM conversion of a formula using Calculated product quantity

EXPECTED BEHAVIOR
-----------------------
To not have a decimal qty when converting

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


1. For formula ‘ABC.123.X’, the DETAIL_UOM for the product ‘ABC’ is LBS.

2. The base UOM of ‘FLUID’ class is GAL (parameter value for FM_YIELD_TYPE parameter for an organization ABC). Since, these UOM’s are different, API is first converting the QUANTITY from LBS to GAL.

3. Here, for item ‘ABC’, conversion between GAL and LBS is defined as following: 1 GAL = 10.16 LBS. So, for a quantity of 3, the converted value will be 0.29529 i.e; 0.09843 (1/10.16)*3.

4 Later, the API will calculate the specific product quantity by converting this converted value in GALLON’s to LBS (the original UOM of the product). So, converting 0.29529 GAL to LBS results in 3.00014 LBS.

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