RWMS Is Generating Sequences With Gaps

(Doc ID 2070664.1)

Last updated on MAY 24, 2017

Applies to:

Oracle Retail Warehouse Management System - Version 13.1 and later
Information in this document applies to any platform.
Checked for relevance 24-May-2017

Symptoms

Gaps are observed in DISTRO_NBR_SEQ database sequence while creating a stock order in Oracle Retail Warehouse Management System (RWMS).

Sample Steps to Recreate (from test case):

  1. Set up 5 items such that the items have all the processes defined but inventory locations have only the applicable processes defined.  (Example: Item '200583' has 42 records in ITEM_DIM_PROCESS, which was stocked in location 'U08E01B05' that has 3 processes defined - BD_ICK, CD_PICK and U_PICK).
  2. Create a new stock order (Distro) using User Interface (UI) in RWMS.  Notice the Distro generated is 7543001200.
  3. Select the DISTRO and run the wave.
  4. Now create a new distro in UI. Notice that the distro has skipped 8 sequences and the new number is 7543001209.

 

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