DEAL_HEAD Sequence is Not Incrementing Correctly as Per the Sequence SQL
(Doc ID 2018619.1)
Last updated on FEBRUARY 26, 2019
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.
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 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.
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