Distribution Cubing Logic Fails to Handle Cubes With Decimals Extending Beyond 2 Digits After Decimal Point and Generates Over-Sized Pick Labels
Last updated on APRIL 10, 2017
Applies to:Oracle Retail Warehouse Management System - Version 13.2 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.
While using meters as the unit of measure for length, width and height, cubing logic fails to handle cubes with decimals extending beyond 2 digits after decimal point and thus generating higher volume pick label that the box cannot handle.
Steps to Recreate:
- Create multiple distros as follows
DISTRO: 103197: QTY: 2 ITEM: 695866000000
DISTRO: 103198: QTY: 3 ITEM: 704133000000
DISTRO: 103199: QTY: 2 ITEM: 704135000000
DISTRO: 103200: QTY: 17 ITEM: 696202000000
DISTRO: 103201: QTY: 12 ITEM: 704133000000
DISTRO: 103202: QTY: 7 ITEM: 704133000000
- The container length, container width and container height in CONT_TYPE should be 0.54, 0.34 and 0.34 respectively.
- Assign U pick to the items
- Run distribution
- Check what the system generated in the table pick_directive, a label that has several items and a total cube of items has the cube of the box.
- Sum cube of PICK_DIRECTIVE table for one of the unit pick label is exceeding the cube in CONT_TYPE table which is 0.54 x 0.34 x 0.34 = 0.62424.
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