My Oracle Support Banner

How To Find the Journals Not Automatically Reversed due to Category Setup (Doc ID 276575.1)

Last updated on JULY 31, 2019

Applies to:

Oracle General Ledger - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Executable:GLPARV - Program - Automatic Reversal


Program - Automatic Reversal was not generating the reversal journals which had been defined on Setup > Journal > Autoreverse as being for autoreversal because when they were created/posted the Autoreverse setup was not correct.

You have corrected the setup but still the journals do not autoreverse.
The missing journals were created before you have defined/updated Autoreversal so that the Reversal Period was NULL in accrual_rev_period_name.
Or the 'Reverse period' from journal categories might be set as 'No default'.

This meant that they were not picked by the program as there is a line in the WHERE clause "and JEH.accrual_rev_period_name is not null".

You need to identify those journals created prior to the update of the Autoreverse entry and reverse them manually.
You will need to set a reversal period in the journal enter screen under more actions in order that they can be reversed.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.