Document Sequencing in General Ledger

Mar 7, 2020 | GL, Oracle

You can assign only one active document sequence scheme to each unique combination of:

  • Application, Category
  • Set of Books
  • Method (Auto or Manual entry)

However, you can assign the same document sequence to more than one combination of Application, Category, Set of Books, and Method.

General Ledger automatically creates journal entries for actual transactions when you perform the following tasks:


Import JournalsReverse JournalsRevalue BalancesGenerate Recurring JournalsGenerate MassAllocation JournalsConsolidate Sets of Books

Why can’t I have multiple Doc Sequences with my Ledger and multiple OU’s? 

Notice in the graphic above the duplicate on the Categories and in the same date range!

Notice in the graphic above that the slice is on Ledger! Not OU.

Notice the error message when trying to be cute!

 Same issue for Receivables

So since Document Sequencing is at the Ledger level you may have multiple OU’s with single LE’s or multiple LE’s in a single OU and you still can’t escape the ledger.  So if there is a real or “perceived” need (when someone sat next to an auditor at lunch and overheard them saying that all LE’s must have their own sequences) then you need to follow a 1:1:1 model i.e. one LE to one Ledger to one OU.. Unless? Custom sequences… omg… Anything is possible for the right $$.

Let's set up a call?

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's set up a call

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's get on a call!

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Subscribe To Keep Up To Date

Subscribe To Keep Up To Date

Join our mailing list to receive the latest news and updates.

You have Successfully Subscribed!

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close