E1: 46L: P46230 - Warehouse Availability Shows Incorrect Quantities for Dual UOM Item (Doc ID 2867413.1)

Last updated on AUGUST 04, 2022

Applies to:

Symptoms

When using License Plate Management with Dual UOM items with Dual Picking (DPPO) activated and adjusting quantity for a License Plate, the P46L30 - Assign/Remove Items To LP switches the primary and secondary quantity of the item. An item set up with primary UOM as Pound (LB) and secondary UOM as Cases (CA) creates a License Plate with primary UOM as Cases (CA) and secondary UOM as Pound (LB). In addition P46230 Warehouse Availability shows a a loose quantity besides the license plate quantity.
This only appears to happen when Dual Picking Process (DPPO) is activated.
  

Steps to Duplicate:
1) Set up Dual UOM item with Dual Picking = ON and primary UOM = LB, secondary UOM = CA
2) Set up UOM conversion 1 PL = 119 CA = 1190 LB
3) P4114 Enter Adjustment for primary quantity 1300 LB , secondary quantity 119 CA
4) P46L30 Note that primary and secondary quantity appear switched around showing 119 CA as primary quantity
5) P46L30 Click Build, enter quantities, Click Add and Save Changes to create license plate
6) P46L10 License Plate is created showing Primary quantity 119 CA, secondary quantity 1300 with a blank Dual UOM
7) Inquire in P46230 Warehouse Availability and it shows the License plate quantities as well as a loose quantity of 1181 (1300-119)
8) Run same Test with with Dual picking OFF
9) P46L30 Note that primary and secondary quantity are correct, showing 1300 LB as primary quantity
10) License Plate is created with correct quantities and P46230 shows correct LP quantities with No loose quantity

Cause

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