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

Enter the dates on which your document sequence takes effect/is no longer enabled. The Start on field automatically defaults to the current date, and once a sequence is defined, the start date cannot be changed. If you leave the End on field blank, your document sequence does not expire; and if you enter an end date and define your sequence, the end date cannot be modified later. If there is no end date defined and there are no active assignments for a sequence, you can disable the sequence by entering the current date as the end date. Once disabled, a sequence cannot be reactivated.

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

Check the Message check box if you want each document to display a message (in the message line near the bottom of the screen) informing the user of the sequence name and value (number).

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

Enter a value for the first document in your sequence. This field only applies to sequences with automatic or gapless numbering type. The maximun sequence value is 1.0e+27.

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.

Extending access to your document sequence to more than one ORACLE username is especially useful when there is more than one installation of a given product, for example, when there are multiple sets of books.

Oracle Username

Select the Oracle Usernames that can access your sequence; more than one application may use a sequence to number their own documents.

Once your sequence is defined, you cannot delete access privileges to Oracle Usernames.

See Also

Document Categories

Sequence Assignments