Procedure Automate_wave Is Not Fetching Unit Pick System Code From Order Query (Doc ID 2217146.1)

Last updated on DECEMBER 27, 2016

Applies to:

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

Symptoms

When automate_wave batch is run, Unit Pick System Code (UPS) comes from the item configuration and not from query definition.

Steps to Recreate:
1. Set up the order query for waving (Item needs to have different UPS code than present in ORDER_QUERIES table).
2. Run automate wave batch with proper parameters.
3. Check STOCK_ALLOCATION_SELECT.UNIT_PICK_SYSTEM_CODE is updated with ITEM_MASTER UPS code.

Changes

 

Cause

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 hundreds of Community platforms