I have a very high transaction database I have multiple sequences to unique generate numbers for different outlets.
One of the outlets started receiving errors because i have a unique constraint on a table to prevent duplicates. The sequence that generates the numbers rolled back more than 10 numbers.
I can afford for this to happen again because it stops sales and I currently have over 70 sequences and going to added more as the months go by.
Has anyone ever experienced this before and how can i stop this from happening in the future ?
any help would be appreciated .. thanks