RWMS Is Generating Sequences With Gaps
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
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 '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).
- Create a new stock order (Distro) using User Interface (UI) in RWMS. Notice the Distro generated is 7543001200.
- 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 7543001209.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms