My Oracle Support Banner

Distribution Does Not Create Sufficient Picks (Doc ID 1983336.1)

Last updated on APRIL 15, 2021

Applies to:

Oracle Retail Warehouse Management System - Version 13.1 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.


Distribution does not create sufficient pick directives to fulfill the store orders even though inventory exists for the items in the warehouse. This happens in the following 2 scenarios:

Scenario 1

Distribution is not creating all of the 'CF' type picks for an item that is associated to an order, even though there is enough inventory in the reserve locations and pick_from_loc and the proper ROP (Re-Order Point) processes are assigned.

Instructions to Re-create

    1. Ensure all SCP parameters are set as reported scenario, specifically changing the pick_by_loc_non and pick_by_loc_con = 'N'.
    2. Create new item, having the processes of  BD, BT, CD, CF, and U, item_master <ITEM_ID> innerpack=1, casepack=4
    3. Associate the item to the forward picking location.
    4. Forward Case having processes of BD, BT, CD, CF, CT
    5. Reserve location having processes of  BD, BT, CD, CT  5 cases having 4 units each
    6. Pick_from_loc record shows the unit_qty = 12,   distributed_qty = 0   capacity = 24, unit_replen_qty = 4, inbound_qty= 0, casepack=4
    7. Stock_allocation has four stores getting 8 units for each store.
      • 1001    item = <ITEM_ID> requested qty =4
      • 1002    item = <ITEM_ID> requested qty =4
      • 1003    item = <ITEM_ID> requested qty =4
      • 1004    item = <ITEM_ID> requested qty =4 
    8. Allocate the order and run_distribution process.
    9. The stock_allocation shows the following:
      • 1001    item = <ITEM_ID> requested qty =8   distributed_qty = 8
      • 1002    item = <ITEM_ID> requested qty =8   distributed_qty = 8
      • 1003    item = <ITEM_ID> requested qty =8   distributed_qty = 8
      • 1004    item = <ITEM_ID> requested qty =4   distributed_qty = 4
    10. The pick_from_loc now reflects as follows:
      • unit_qty = 12, distributed_qty = 28, capacity = 24, unit_replen_qty = 4, inbound_qty= 0, casepack=4
    11. Rollback the order and schedule_rop_distribution and still the same results occur.


Scenario 2

The running of distribution where picks are going to be created out of a forward picking location, CF_PICK_SYS, when allocating the orders, only two are being allocated.  However, immediately following, selecting the remaining orders for the item, and running the distribution process, the orders are now allocated.

Instructions to Re-create

    1. label reserve = ‘N’
    2. Create item having CF Pick Sys, and BD pick processes
    3. Create forward case location having CF and BD pick process
    4. Associate item with forward case location with unit qty = 3, capacity = 137, casepack = 1
    5. Create pallet inventory in a reserve location (location having BD process), having 135 containers (casepack = 1)
    6. Create 13 orders to 13 stores
      • Stores 2, 3, 5, 8, and 13 each requesting 2 cases and the rest of the stores requesting 1 case for a total of 18 cases
    7. Wave these orders, only the first two orders are distributed and now the pick from loc has unit qty = 0
    8. Rewave the remaining 11 orders, they are now distributed.




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.