Previous | Next | Contents | Index | Navigation | Glossary | Library |
Attention: Your database administrator must grant access to an application's audit table for all ORACLE usernames associated with responsibilities that will use the sequence (responsibilities that access forms using the sequence).
You can set start and end dates for when the sequence is available. The start date defaults to the current date. By default, there is no end date, so the sequence definition does not expire.
You can choose whether a sequence numbers documents automatically, or accepts numbers manually entered by a user.
Gapless numbering also automatically generates a unique number for each document, but ensures that the document was successfully generated before assigning the number. With Gapless numbering, no sequence numbers are lost due to incomplete or failed document creation.
Attention: We recommend that you choose this type only when gapless numbering is essential, as it may affect the performance of your system.
Manual numbering requires a user to assign a unique number to each document before it is generated. With manual numbering, numerical ordering and completeness is not enforced. Users can skip or omit numbers when entering the sequence value.
Examples - Automatic vs. Manual Sequences
Field in Document Sequences form | EXAMPLE 1 Sequence with Automatic Numbering | EXAMPLE 2 Sequence with Manual Numbering |
---|---|---|
(Sequence) NAME | AUTOPAY | ADJUSTMENTS |
(Owning) APPLICATION | ORACLE PAYABLES - Sequence can number documents stored in an Oracle Payables database table. | ORACLE RECEIVABLES - Sequence can number documents stored in an Oracle Receivables database table. |
EFFECTIVE DATE - START | CURRENT DATE & TIME (Default value) | OCT-01-94 User defines sequence "Adjustments" not to be available until Oct 1, 1994. |
EFFECTIVE DATE - END | Field left blank. Sequence does not expire. | DEC-31-94 User defines sequence "Adjustments" to no longer be available after Dec 31, 1994. |
(Numbering) TYPE | AUTOMATIC - Unique numbers are automatically generated in sequence. GAPLESS No omissions or gaps in numbers are possible, due to a rollback if the document creation is unsuccessful. | MANUAL - User must enter a unique number before transaction can be completed, and document is generated. User may skip or omit numbers. |
INITIAL VALUE | 1 (Default value) User could enter their own initial value, for example, 5700. | Not Available when numbering type is Manual. |
MESSAGE | YES - When a document that is automatically numbered is created, a message displays the sequence name and the sequence value (document number). | Not Available when numbering type is Manual. |
Table 1 - 27. (Page 2 of 2) |
Previous | Next | Contents | Index | Navigation | Glossary | Library |