After Bulk Picking, Unable To Track MASTER_CONTAINER_ID on CONTAINER Table
Last updated on OCTOBER 12, 2017
Applies to:Oracle Retail Warehouse Management System - Version 12.0.5 and later
Information in this document applies to any platform.
Consider an item that has inventory in a master pallet with 10 cases, each containing 10 units. After shipping that master pallet, the MASTER_CONTAINER_ID is deleted from the CONTAINER table and the child containers get a new container as MASTER_PALLET_ID. As such, the original MASTER_CONTAINER_ID cannot be tracked.
Steps to Recreate:
1. Create two stock orders for an Item for the same store (100) as below:
- Distro1 -- Store100 -- Item1 -- 60 Units
- Distro2 -- Store100 -- Item1 -- 40 Units
2. Select both stock orders in the Select Stock Order Screen and assign for the same wave.
3. Run the distribution script.
Two pick directives are generated with the same PICK_TO_CONTAINER with Pick_Type=Bulk.
While printing the labels, note that 11 labels are printed: 1 Master Bulk Label + 10 Bulk Labels (each Case).
The picking will be done by using only the Master Bulk Label.
After shipping that MASTER_PALLET_ID, the MASTER_CONTAINER_ID is deleted from the CONTAINER table, and the child containers get a new container as MASTER_PALLET_ID.
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