My Oracle Support Banner

Put To Store Unit Picking Does Not Allow Picking From a Container That is Multi-SKU (Doc ID 1066219.1)

Last updated on APRIL 19, 2021

Applies to:

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


When performing Put To Store (PTS) Unit Picking where a replenishment (UP pick type) container is MULTI_SKU,  it is not possible to pick all of the items from the container.

Steps to Reproduce:

Data setup:
2. Items set up (10001005, 10001006, 10001007) with the UNIT_PICK_SYSTEM_CODE = 'PTS'. Processes included UP_PICK and U_PICK.
3. Ensure the items are associated to a less than case location and inventory is available.
4. Ensure the PTS is set up for the stores to be picked for, with locations defined.
5. In order to get a multi-SKU container out of the less than case area, the UNIT_PICK_ZONE will need to have the MULTI_SKU flag checked yes.

1. Create an order for the three items for three stores, such that each store is getting a couple of units for each.
2. Associate the order to a wave and run the distribution process.
3. Review the PICK_DIRECTIVE table; it reflects the PICK_TO_CONTAINER_ID is the same for each UP_PICK.
4. Print the wave.
5. Perform the less than case picks (Unit Picking) for the container having multiple items in it.  Note the CONTAINER_ITEM records for the container were for all three items each having seven units for them.
6. Using the MOVE screen, move the container to the PTS Picking area, PTS drop-off location defined.
7. Navigate to the PTS PICKING --> PTS Unit Picking.
8. Enter the zone.
9. Enter the container ID, the PICK_TO, containing the three items.  You will be directed to complete all the picks for the first item.
10. Once all the picks are completed for this item, the user is presented with the following question: 'Is the Inbound Carton Empty?'   Before acknowledging the question, review of the CONTAINER_ITEM records for the container show that the item just picked has a UNIT_QTY=0, the remaining two items have the UNIT_QTY of 7.  Further review of the PICK_DIRECTIVE reflects that the remaining two items have 'U' picks to be completed that total 7 units for each.
11. Respond to the question as NO (since one would think there are still items in the carton).  The grab quantity is then asked for and the number 14 is entered, since there are still 7 units of the other two items existing in the container.  Once this is done, the CONTAINER_ITEM table is updated, and the item just picked now reflects a UNIT_QTY=14, the DISTRO_NBR changed to 'NONE'.
12. Enter the Container ID again.   Now the message of 'No remaining picks' is displayed, even though there are still picks in the PICK_DIRECTIVE table for this pick to container ID.    You are thus not able to continue the picking for the remaining two items that are in the container.




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.