If Item Cube Is Too Big, System Will Not Allow User To Select All Lines From The Wave in Select_Stock_order Screen
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.
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”
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