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 AUGUST 10, 2017

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.

Symptoms

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_SOURCE  : SELECT_MANUAL_ORDER
 ERROR_LOC        : pkg line_order_level  
 ERROR_MSG       : OTHERS=>selected_distro, ORA-06502: PL/SQL: numeric or value error: Bulk bind: Error in define”

Changes

 

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