My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2022

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


NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.


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 <CODE COMBINATION 4> for £200 but  it was put to one of the error accounts instead account combination  <CODE COMBINATION 3>
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 <CODE COMBINATION 3> now has a YTD balance in the new year of £200 which you need to remove.




To view full details, 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 a vibrant support community of peers and Oracle experts.