My Oracle Support Banner

Validation Is Incorrect When There Is No Warehouse Defaulted For A Store (Doc ID 2215392.1)

Last updated on DECEMBER 23, 2016

Applies to:

Oracle Retail Allocation - Version 14.1.1 and later
Information in this document applies to any platform.


Problem Description

If there is no STORE.default_wh and no WH_STORE_ASSIGN.wh value, a store selected in an allocation shows as valid in the Locations pane.

Steps to Reproduce

1. Ensure that there is no value for default warehouse in either STORE or STORE_WH_ASSIGN.
2. Select a Staple item.
3. ITEM_LOC has source_wh. (I didn’t test the same if Supplier had been selected rather that Warehouse for source. In theory, it shouldn’t matter. BUT must be tested.)
4. Create an allocation for an item from some warehouse or PO.
5. Add current release date (current or future shouldn’t matter in this case either)
6. Add store that has a valid ITEM_LOC relationship with the above conditions for warehouse.
7. Enforce Supply Chain
8. Note that in the Locations section, the store is valid. (It should not be because the warehouse through which the item is coming is not valid.)
9. Manual Rule
10. Add a Final Quantity in the Results section and Save.
11. Note - No errors.
12. Approve the allocation.
13. Open the allocation.
14. Status Error – mouse over and error reads The total supply chain available inventory is insufficient to meet the allocated quantities. (This makes no sense.)
15. The store is still showing as valid.


To view full details, 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 a vibrant support community of peers and Oracle experts.