My Oracle Support Banner

RWMS Is Generating Sequences With Gaps (Doc ID 2070664.1)

Last updated on DECEMBER 04, 2019

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 '200001' has 42 records in ITEM_DIM_PROCESS, which was stocked in location 'U08E01B05' that has 3 processes defined - BD_PICK, CD_PICK and U_PICK).
  2. Create a new stock order (Distro) using User Interface (UI) in RWMS.  Notice the Distro generated is XXXXXXX200.
  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 XXXXXXX209.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.