My Oracle Support Banner

If Item Cube Is Too Big, System Will Not Allow User To Select All Lines From The Wave in Select_Stock_order Screen (Doc ID 2294752.1)

Last updated on MARCH 03, 2019

Applies to:

Oracle Retail Warehouse Management System - Version 14.0 to 14.0.4 [Release 14.0]
Information in this document applies to any platform.


If item cube (Length x Width x Height ) is a large number, system will not allow user to select all lines from the wave.

Steps To Recreate:
1.Create an item with dimensions  where the cube for a single unit is 88888888.0000.
2.Create an Inventory Adjustment to create inventory in the system.Move the pallet to Reserve location.
3.Create a transfer for 10 units of this item for a store on a single distro line.
4.Go to “Select Stock Order” screen and enter the query to select this distro line.
5.When query results are displayed, use “Add All” option to so that all lines can be selected for waving.
Expected Results: System should all lines from top block to bottom block all at the same time.
Actual Result: System does nothing and does not give any error.

System also logs an error in the ERROR_LOG table.

 ERROR_LOC        : pkg line_order_level  
 ERROR_MSG       : OTHERS=>selected_distro, ORA-06502: PL/SQL: numeric or value error: Bulk bind: Error in define”


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.