My Oracle Support Banner

Distribution Cubing Logic Fails to Handle Cubes With Decimals Extending Beyond 2 Digits After Decimal Point and Generates Over-Sized Pick Labels (Doc ID 2023673.1)

Last updated on NOVEMBER 08, 2019

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:

  1. 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
  2. The container length, container width and container height in CONT_TYPE should be 0.54, 0.34 and 0.34 respectively.
  3. Assign U pick to the items
  4. Run distribution
  5. 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.
  6. 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.





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.