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
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):
- 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).
- Create a new stock order (Distro) using User Interface (UI) in RWMS. Notice the Distro generated is XXXXXXX200.
- Select the DISTRO and run the wave.
- Now create a new distro in UI. Notice that the distro has skipped 8 sequences and the new number is XXXXXXX209.
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