Tare Weight Unit Of Measure Not Taken Into Account When Re-Generating Ship Units. (Doc ID 1336093.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.0 to 6.2.3 - Release: 6.2 to 6.2
Information in this document applies to any platform.

Symptoms

On OTM version 6.2.0 when Items and Ship Units are created using weights with a Unit Of Measure (UOM) that is not the details for the install, when Ship Units are recreated the UOM is ignored and the system base UOM is used.

For example is the Tare Weight is entered as 50 KG but the system default UOM for weight is LB then when the Ship Unit is recreated 50 LB will be used in place of 50 KG.

EXPECTED BEHAVIOR
-----------------------
Expect the Tare weight to be used with the UOM it was created with.

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

1 - Check the UOM base values by running the following SQL:

SELECT * FROM UOM WHERE IS_STORAGE_DEFAULT ='Y'

LENGTH FT
DISTANCE MI
VOLUME CUFT
WEIGHT LB
TEMPERATURE F
SPEED MPH
DENSITY LB/CUFT
CURRENCY USD USD

2 - Build an XML file to create the Item where metrics are in KG, CM and CUMTR, not the default UOMs of the system.

3 - Upload the item file, the following is created:
Item: 1234
Ship Unit: 1234

Note the Tare Weight is 41.36KG.

4 - Create an XML file to use the Item and Packaged Item and upload it into OTM.

5 - The Order Release isi created.

6 - Expected Values in KG:

Gross Weight = 540.8 KG (499.54 + Tare Weight 41.360 KG)
Net Weight = 499.54 KG (= 40 x 12.486 KG)

Converted to LB:
Gross Weight: 1192.61 LB
Net Weight 1101.43 LB

7 - Navigate to the Order Release, Ship Unit tab and the above weights are shown in LB.

8 - Click on Actions > Change Order > Generate Ship Units.

9 - The UI will display the following message:

Confirmation
Ship Units for Order Release 1234 have been successfully generated.

10 - Return to the Order Release, click Edit and go to the Ship Unit tab.

11 - In LB the UI now shows:
Total Gross Weight: 1142.79 LB
Net Weight per Ship Unit: 1101.43 LB

12 - The Total Gross weight has changed, it should have remained the same. The Tare Weight being used should have been the tare figure in KG but OTM used the tare figure in 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