Previous  Next          Contents  Index  Navigation  Glossary  Library

Sequences

Identify an application sequence to Oracle Applications. You can also use this window to register changes to your sequences.

Tables

Prerequisites

Sequences Block

Start With

Enter the first number that this sequence should generate. The value in this field must always be between the Minimum Value and Maximum Value inclusive.

Increment

Enter the interval between sequence numbers. The increment can be positive or negative. If you enter a negative value, the sequence descends. You cannot enter a value of zero.

Minimum

Enter the minimum value this sequence can generate. This value is the lower bound for the sequence. You must enter a Minimum Value that is less than the Maximum Value.

Maximum

Enter the maximum value the sequence can generate. This value is the upper bound for the sequence. You must enter a Maximum Value that is greater than the Minimum Value.

The default value is 2,147,483,647.

Cache Size

Enter the number of sequence numbers to cache in memory, resulting in faster generation of sequence numbers.

You must enter a value greater than or equal to 0.

The default value is 5.

Cycle

Check if you want the sequence to generate additional numbers when the end of the sequence is reached. Otherwise, leave the check box off.

Guarantee Order

Check if you want the sequence to generate numbers in order of request. Otherwise leave the check box off.


         Previous  Next          Contents  Index  Navigation  Glossary  Library