EGL.9.2:Allocation Journal With 0 Total Amount In Base Currency Is Not Getting Displayed On Ledger Inquiry Page (Doc ID 2949700.1)

Last updated on MAY 17, 2023

Applies to:

Symptoms

Allocation Journal is not appearing in the Ledger Inquiry results when it has a 0 total amount in Base Currency.It is displayed on Journal Inquiry results.

Issue can be replicated following the next steps :

1.Create a new Business Unit  with currency TTD ( Set Up Financials/Supply Chain  >  Business Unit Related>General Ledger>General Ledger Definition).

2.Add a Ledger group to new BU- RECORDING and calendar 01 (Set Up Financials/Supply Chain  >  Business Unit Related>General Ledger>Ledger for a Unit) .Open the hyperlink Open Period and Update period.

3.Check Ledger Group (General Ledger>Ledgers>Define Ledger groups for RECORDING).

4.Check Time span used in allocation (Setup Financial>Common Definition>Calendars>Time Spans).

5.Create journals for newly created BU (General Ledger>Journals>Create/Update Journals).

6.Allocation Step- Set up (Allocations > Define and Perform Allocations >Define Allocation Step ).

7.Define Allocation group (Allocations > Define and Perform Allocations >Define Allocation Group)

8.Run Allocation (Allocations > Define and Perform Allocations > Request Allocation) .

9.Notice that the Allocations journal has zero amount. When trying to post it, there are several warning messages that appear, but the journal is posted.

10.Check Ledger Inquiry (General Ledger >Review Financial Information>Review Ledger Information) and check for the account xxxxxxx if allocation journal is there - !!! not present .

11.Check Journal Inquiry (General Ledger >Review Financial Information>Review Journals) for allocation journal. Journal is present.

Check the attached replication document for more details.

Changes

Cause

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