Document sequence setup in oracle apps r12

Document sequence setup in oracle apps r12

In this post, We will discuss about Document sequence setup in oracle apps r12. Document sequence helps to assign the number to Oracle transactions which occurs more than once, by numbering them you can identify the order of its generation. It acts like a chain and if a number goes missing, the link is broken and you can see that there was a deletion or removal of the transaction. Document sequence setup in oracle apps r12 helps to assign the unique sequence for each transaction based on the category and then after that, system refer that sequence number for generating numbers for that category transactions. In general business practice we create the document sequences for each transaction every year for audit point of view. Here below I will share the complete Document sequence setup in oracle apps r12.

 

Detail steps for Document sequence setup in oracle apps r12

Step1:- Go to General Ledger responsibility

 

Setup => Financials ==> Sequences

 

 

 

 

Step2:- In this Step We define the Sequences

Sequences ==> Define

Here,
a) Give a name to your order Sequence,
b) Select Applications as : Receivables
c) Select effective dates
d) Type: Choose as Automatic.
e) Select a Initial Value. Lets take it as 2500 in our case.
f) Save your work

 

 

Step3:- We have already defined our Document sequence in the Last Steps now we will assign the that sequence to the Transaction Category.

 

Define Document Categories

You can create a document category for shipping documents such as a packing slip, bill of lading and assign it to a location or all locations.

But for for new transaction types, a new document category gets created automatically with same Name

 

Assign Document Sequence

After defining document sequences and categories, we need to assign document sequences to document categories.

 

 

 

 

Step 4:- Here below is the document sequence assignment part 2.