General Ledger Account Inquiry Form Shows Incorrect Balances For Total Currency And Entered Currency After R12 Upgrade
(Doc ID 2990456.1)
Last updated on DECEMBER 19, 2023
Applies to:
Oracle General Ledger - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
Steps to reproduce the issue:
1. Navigate to the Account Inquiry window.
General Ledger> Inquiry > Account
2. Enter the range of Accounting Periods to include in your inquiry.
3. Specify the currency to include in the inquiry:
Select All Currencies to see account information in all currencies.
Select Single Currency and enter a Currency to see only balances entered in or translated to that currency.
4. Choose to see balances from transactions Entered in the inquiry currency, or balances Translated to that currency. You must choose Entered balances if the inquiry currency is your functional currency or STAT.
5. From the poplist, choose Primary Balance Type.
6. Specify whether you want to see Actual, Budget, or Encumbrance balances.
7. Verify Account Balances for Total Currency and Entered Currency. (You can verify the balances using a Trial Balance report)
Example
The GLACTANL2 Account Analysis - (180 Char) report is not showing the correct beginning and ending balances.
If it is run for :-
currency = EUR
currency type = Entered
Period = Jan-23 to Mar-23
Although the output shows the balance for Period Jan-23 1= 2082.74
the beginning balance and ending balance both show 0 DR
If it is run for:-
currency = EUR
currency type = total
Period = Jan-23 to Adj-23
then it shows
beginning balance = 2585.12 DR
ending balance = 97908.57 DR
If it is run for :-
currency = GBP
currency type = Entered
then it shows
beginning balance = 0.00 DR
ending balance = 4907.00 DR
So there is no consistency in when the report is displaying values for beginning and ending balances.
Changes
EBS Application upgrade from R11i application to R12.
Cause
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
Symptoms |
Changes |
Cause |
Solution |