Thursday, June 18, 2015

Posting Throws 'APP-SQLGL-08090: Please open the period you have selected for this batch before posting

Cause:

This error is thrown when the batch being posted is expected to affect multiple ledgers (including Reporting Currencies) which do not have the same periods opened. 

In R12 a batch can contain many journals for many ledgers. They should all have the posting period for the batch opened, otherwise the error will be thrown and the batch will not post.

Solution:

1. Identify all ledgers affected by this batch being posted
2. Make sure they all have the posting period in Open status
3. Retest after opening the needed periods and confirm this worked fine

To avoid re-occurrence of this issue you could define a Ledger Set including all your ledgers and consider opening the periods for it.

Oracle General Ledger Implementation Guide page 1-122

Defining Ledger Sets
A ledger set is a group of ledgers that share the same chart of accounts and calendar/period type combination. Ledger sets allow you to run processes and reports for multiple ledgers simultaneously.
For example, you can open/close periods for multiple ledgers at once [...]

1 comment:

  1. Great post!!Thanks for sharing it with us....really needed.Ordering Checks online is a lot easier than most people realize. It takes only a few minutes from start to finish. You will never need to concern yourself with having someone else do this task for you ever again.
    Cheap personal checks

    ReplyDelete