My Oracle Support Banner

Decimal Quantity Calculations Incorrect When Performing LPN Split (Doc ID 2510231.1)

Last updated on FEBRUARY 24, 2023

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Materials Management

Both tables show different value of LPN 649 and the value is incorrect .The value should be LPNXXX 93 GRM and LPNXXX @100 GRM

NOTE: In the  examples   below document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.



The issue can be reproduced at will with the following steps:
org : W1 (organizatoin_id 1884)
Item mtm_lbs_gram3 (inventory_item_id 2504326)
enter : 480 lbs (to simulate customer )
Conversion for Grams of pounds : 0.00220462

lpn XXXX
Packed : 193 Grans this converted to .42549 pounds

split 2071185 into 2071186
2071185 will have 93 grams left
2071185 will have 100 grams


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.