ORA-06502 Error Occurs When Distributing Items With ITEM_CUBE of at Least 8-Digit Whole Number; Such Items Are Kicked from the Wave (Doc ID 1620337.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Warehouse Management System - Version 13.2 and later
Information in this document applies to any platform.

Symptoms

In Retail Warehouse Management System (RWMS),  length, width, and height dimensions have a data limit of NUMBER(12,4).   However, when items have dimensions set as millimeters/centimeters and dimensions have values of at least 3 digit whole numbers (e.g., 336mm x 300mm x 398mm), ITEM_CUBE (NUMBER(12,4)) will have an 8-digit whole number (e.g., 40118400).   During distribution in RWMS, an error is shown in the ERROR_LOG:


This is from computing the ITEM_CUBE multiplied by UNIT_QTY (if greater than 10) in DE_CREATE_RF_UNIT_PICK and storing the computed value in a variable (t_cube) with data declaration of NUMBER(12,4).



Steps to Reproduce:

  1. Distribute an item with ITEM_CUBE with at least 8 digit whole numbers (e.g., 12345678) and REQUESTED_UNIT_QTY greater than 9.
  2. Note the error above in ERROR_LOG.

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