After Bulk Picking, Unable To Track MASTER_CONTAINER_ID on CONTAINER Table

(Doc ID 1418668.1)

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.

Goal

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.

Solution

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