My Oracle Support Banner

Container Pick Swapping for Bulk Container Results in the Bulk Container Not Being Decremented Properly (Doc ID 1267134.1)

Last updated on FEBRUARY 02, 2022

Applies to:

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


When swapping a pick that was created for a single case container to a pick from a bulk container, the bulk PICK_FROM_CONTAINER_ID is decremented incorrectly.  This causes the pick to container to be updated incorrectly for PICK_FROM_CONTAINER_ID value in the CONTAINER table.

Steps to Recreate:
1. Create a new item having a casepack=1, inner pack=1.
3. Create a new reserve location, having the processes of BR_PICK, BT_PICK,  CR_PICK, CT_PICK_FROM_STORAGE and C_PICK.
4.  Ensure the CONTAINER_SWAPPING attribute is on the item and the location.
5. Create inventory in the reserve location as follows:
     a. 5 single cases in the location, each for one unit.
     b. Bulk pallet in the same location has a case qty of  5, each for one unit.
6. Create a stock order, for one store requesting two units.
7. Review of the PICK_DIRECTIVE shows that two single cases will be picked.   The Inv Inquiry by Item screen shows two containers as distributed.
8. Print the wave.
9. In the RF Case Picking screen, enter the master container ID; press F1 Display.
10. From the first container that shows the required qty = 1. Enter the confirm container of the pallet to swap a container and press Enter.
11. Note the First and Last Container are displayed. Press F4-Done.
12. Second pick is shown with the From CID of the second container with the required quantity.
13. Enter the pallet in the Confirm CID to swap a container and press Enter.
14. First and last container is shown. Press F4-Done.
15. Get the "No remaining picks" message.
16. Now in the Inv Inquiry By item screen, the single containers show as available, but the pallet shows a quantity of 2, rather than 3, since 2 cases were swapped for.


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.