GL Opening Balance Incorrect Due to Misclassified Accounts Wrongly Corrected (Doc ID 342281.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 11.5.9 to 12.1.3 [Release 11.5.9 to 12.1]
Information in this document applies to any platform.
Executable:GLACTANL - Account Analysis - (132 Char)
Executable:GLACTANL2 - Account Analysis - (180 Char)
Executable:GLACTANP - Account Analysis - Payables Detail(132 Char)
Executable:GLACTANP.RDF - Account Analysis with Payables Detail
Executable:GLACTANP180 - Account Analysis - Payables Detail(180 Char)
Form:GLXIQACC.FMB - Account Inquiry

Symptoms

You have a misclassified account that has been corrected using <Note.1050920.6> or <Note.872162.1> but mistakes were made so there are still incorrect bought forward amounts . You now have a correctly classified code combination but the amount bought forward into the new year is still wrong.

While creating the journal in Adjustment period to move the balance off the account combination, the double entry was created back to  the same account combination.
e.g.

10.100.1000 150dr
10.200.1000 50 dr
10.300.1000 0

Created a journal with a line to credit each of the above account combinations.
The double entry should have been debited to a holding account 10.100.9000  for £200 but  it was put to one of the error accounts instead account combination  10.300.1000
The journal was saved and posted. The account combination type was changed using sql as per the misclassified note. The journal was then reversed and posted.
As a result account combination 10.300.1000  now has a YTD balance in the new year of £200 which you need to remove.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms