Previous | Next | Contents | Index | Navigation | Glossary | Library |
A document sequence uniquely numbers documents generated by an Oracle Applications product (for example, invoices generated by Oracle Receivables). Using the Sequence Assignments window, you assign your sequence to number only those documents that satisfy rules you define.
Document sequences ensure that every document your users create can be accounted for. See: Sequences Assignments.
Name
Once entered, sequence names cannot be changed.
Application
Once selected, the application associated with your sequence cannot be changed.
You grant access to your document sequence from Oracle Applications products by selecting their ORACLE usernames in the Access block.
Audit records for your sequence are stored in the application's audit table, titled Application Short Name_DOC_SEQUENCE_AUDIT. For example, the audit table for a sequence owned by Oracle Payables is AP_DOC_SEQUENCE_AUDIT.
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 windows using the sequence).
Effective From/To
Type
Once defined, you cannot change the type of document numbering sequence.
Automatic | Sequentially assigns, by date and time of creation, a unique number to each document as it is generated. |
Manual | Manual numbering requires a user to assign a number to each document before it is generated. |
You must enter unique values. However, please note that numerical ordering and completeness is not enforced. |
Attention: The Automatic-By-User type is currently not supported, and is reserved for a future version of Oracle Applications.
Warning: The Gapless Numbering type is valid only in the context of certain localizations. We recommend that you choose this type only after consulting with Worldwide Support, as it may affect the performance of your system.
Message
This check box only applies to sequences with the automatic type of numbering. Messages appear only on form displays, and are not written to a request's log file.
Once a sequence is defined, the message choice cannot be changed.
Initial Value
If you leave this field blank, the first document is automatically assigned a value of "1".
Once a sequence is defined, this initial value cannot be changed.
Oracle Username
Once your sequence is defined, you cannot delete access privileges to Oracle Usernames.
Previous | Next | Contents | Index | Navigation | Glossary | Library |