ORA-06502 Error Occurs When Distributing Items With ITEM_CUBE of at Least 8-Digit Whole Number; Such Items Are Kicked from the Wave
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.
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:
- Distribute an item with ITEM_CUBE with at least 8 digit whole numbers (e.g., 12345678) and REQUESTED_UNIT_QTY greater than 9.
- Note the error above in ERROR_LOG.
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