My Oracle Support Banner

After Bulk Picking, Unable To Track MASTER_CONTAINER_ID on CONTAINER Table (Doc ID 1418668.1)

Last updated on APRIL 15, 2021

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.


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.