E1: 46: Parts List (P3111) Quantity Incorrect After Pick Suggestion Confirmation Override (P4617) Creates Split Parts List Lines when Using a Unit of Measure that has Multiple Primary UoM Quantities, (Example 1 CS = 800 OZ) (Doc ID 2898074.1)

Last updated on FEBRUARY 24, 2023

Applies to:

Symptoms

Parts List quantity is updated incorrectly with a decimal quantity when the remaining suggestion is confirmed.  At P4617, Pick Confirmation, use the Override row exit to split the original suggestion (3 CS / 2400 OZ) and confirm 1600 OZ to split the Parts List.  The parts list now has 2 lines 1 CS &  2 CS.  After confirming the remaining suggestion, (qty = 1 CS / 800 OZ), the Parts List is updated and now shows quantity with added decimals, 1.0025.

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

1.  Create Bill of Material (P3002) with Parent item A and item B as the component.
2.  The Bill of Material (BoM) detail line is for 3 cases of item B.
3.  Item 1 CS = 800 OZ.  OZ is primary uom.
4.  Ample on hand quantity exists for the component item.
5.  Create a work order (P48013) for this BOM, Work order for 1 CS of parent item A.
6.  Advance WO status from 10 - 40 using R31410.
7.  A Pick Request (P3111) is created.
8.  Generate Pick Suggestion for the request, P46171.
9.  Should now have a pick request where the detail is for the component item B and quantity = 2400 OZ.
10.  In P4617 - Pick Confirmation use the Override row exit, Change the Quantity from 2400 OZ to 1600 OZ and then select the Confirm row exit.
11.  The Parts List should now show how it has been split due to the override.
12.  There should be two lines – one for 1 CS and one for 2 CS. 
13.  In P4617 you should see 2 pick suggestions, (Trips 1.000 & 1.001).  Confirm the first suggestion.
14.  Check the WO parts list again – there should now be one closed line and one open line.
15.  The open line has an incorrect decimal quantity (i.e. 1.0025 CS instead of 3 CS for this example).

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.