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:

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

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