DEAL_HEAD Sequence is Not Incrementing Correctly as Per the Sequence SQL
Last updated on MARCH 31, 2017
Applies to:Oracle Retail Merchandising System - Version 13.2.6 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.
In Oracle Retail Merchandising System (RMS) 13.2.x, the sequence in DEAL_HEAD is not incremented by 1 as expected, and there are huge gaps in between the consecutive DEAL_ID's.
Steps to Reproduce:
- Create fixed and complex deals in Retail Merchandising System (RMS).
- Execute all batch processes to fully complete the deals processing, including document creation in Retail Invoice Matching (ReIM).
- Create a fixed or complex deal in RMS screen.
- Notice that the next deal ID number is a high value, not the last deal ID created plus 1.
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