A day in the life of an Oracle Applications Consultant

Tuesday, February 15, 2005

Journal AutoReverse Profile Option

This post highlights a profile option you need to be aware of when setting up AutoReversing journals.

Oracle Apps gives you the ability to manually or automatically reverse posted journals into subsequent accounting periods. We set up AutoReversing journals at a client site the other day so that the journal would automatically reverse in the next non adjusting accounting period i.e. if you were in period 12 of a year it would not reverse the entry in period 13 (an adjustment period) but rather into the first period of the next year. A typical example of where you might want to do this is in the case of an accrual that you raise at the end of month which you now want to reverse in a subsequent month - see the diagram below.

An example of how to set up Journal Reversal Criteria

Having completed the setup our expectation was that the journal would reverse when opening the next month (which is the trigger that runs the Automatic Reversal Programme). To our surprise the journals didn’t automatically reverse in the next month, however, the solution was a simple one. By setting the Profile option GL: Launch AutoReverse After Open Period to Yes we now found that when opening the next accounting period two concurrent requests were spawned, one to reverse the journal and another to post it (as enabled by selecting the AutoReverse and AutoPost Reversal options shown in the above diagram) . If you do forget to turn on this profile option as we did, you can still go and manually reverse the journal by choosing the following navigation path in General Ledger: Journals > Generate > Reversal. The result will be a list of journals which you can manually choose to reverse as shown in diagram below.

Use this form to manually reverse journals

Further Information

Also refer to these two processes documented using Oracle Tutor at the Enterprise Services Center Helpdesk