Saturday, 9 January 2021

Automatic and Gapless Sequencing in Oracle

What is Automatic and Gapless Sequencing in Oracle

In this post we will see what is automatic and gapless sequencing/numbering in oracle cloud.

Document sequencing is a very important setup for any organization. This is basically done for control and audit point of view. We can track what invoices/payments are created and then deleted, as these sequences are unique and assigned to each transaction in respective module.

We have GL sequencing, Payables document sequencing, Receivables document sequencing etc.

So, we have now understood what sequencing/numbering is, let us see how many types of sequencing are available.

Types of Sequencing

1. 1. Automatic

2. 2. Gapless

3. 3. Manual

What is Manual Sequencing/numbering?

From the name is quite clear that in Manual Sequencing/Numbering user must provide the sequence number when he creates a transaction. Hence in such cases the numerical ordering is not maintained, and user can enter the number whichever he wishes.

What is Automatic and Gapless sequencing/numbering in oracle?

1. What is Automatic Sequencing/numbering?

When you create Payables/receivables sequencing and you assign sequencing type as Automatic, it means system will generate the document/sequence number for this automatically whenever a transaction is done. These number are unique and sequential.

The system creates the sequence with the combination of sate and time of creation.

2. What is Gapless sequencing/numbering?

When you create a payables/receivables sequencing and you assign a sequence type as Gapless, it is similar to automatic sequencing but additionally here you can provide the initial number and system will take that as initial sequence and then follow gapless sequence.

For example you created a sequence and taken type as Gapless and given the initial number as 100 . So the system will assign the first sequence as 100 and then creates gapless numbering as 101,102 and so on