Design of gap-free invoice number or check number
Kok AikJan 7 2009 — edited Jan 7 2009Hi, i have this "old question" that i can't seems to find the answer that satisfy the following requirment
- An audit requirement to have a gap free in the invoice number/check number
- this is a high concurrent oltp in generating invoices/checks
- the design should be able to scale well without serialization issue
- the design should be working well in RAC environment.
Since sequence will not guarantee gap-free, or nocache suffer will have issue in RAC, thus i wondering what design approach i should use.
A note i saw was saying using a seq for the primary key and subsequent using a batch process to generate a gap-free number.
rgds
Ung
Edited by: Kok Aik on Jan 7, 2009 10:17 PM