My Oracle Support Banner

Duplicate Records Inserted for C Pick Containers in CONT_LABELS_TO_PRINT Table (Doc ID 2122353.1)

Last updated on APRIL 15, 2021

Applies to:

Oracle Retail Warehouse Management System - Version 14.0 and later
Information in this document applies to any platform.


When printing picking labels via zebra printer, for all the picks generated with Case type picking, the master and child container labels are printing in duplicate. The same container is getting looped multiple times and duplicates are generated in the CONT_LABELS_TO_PRINT table.

Steps to Recreate:

1.       Have 2 containers with same item at a reserved location, one with 10 units and other with 20 units.

2.       Create 2 stock orders for the same destination location (Store1 and Store2) for 10 and 20 units respectively.

3.       Associate the 2 stock orders to the same wave.

4.       Run the distribution batch to generate C-pick in PICK_DIRECTIVE table with same PICK_TO_CONTAINER_ID.

5.       Print the wave.

6.       Notice there are 2 entries for the same PICK_TO_CONTAINER_ID from PICK_DIRECTIVE table created in CONT_LABELS_TO_PRINT table.


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.