My Oracle Support Banner

Journals Real Time Report Does Not Show Legal Entity Name For All Records (Doc ID 2257283.1)

Last updated on NOVEMBER 10, 2019

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Post Journal Entries

ACTUAL BEHAVIOR
---------------
When running an OTBI custom report using the General Ledger - Journals Real Time, the report does not show every time the LE name.


EXPECTED BEHAVIOR
-----------------------
The report should show every time the LE name

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a custom report in OTBI using the query below:
SELECT "- Header Details"."Journal Legal Entity" saw_0, "General Ledger - Journals Real Time"."- Account"."Concatenated Segments" saw_1, "- Line Details"."Line Effective Date" saw_2, "- Line Details"."Line Period Name" saw_3, "General Ledger - Journals Real Time"."- Batch Details"."Batch Name" saw_4, "General Ledger - Journals Real Time"."- Header Details"."Header posting Account Seq Value" saw_5, "General Ledger - Journals Real Time"."- Journal Category"."User Journal Category Name" saw_6, "General Ledger - Journals Real Time"."- Journal Source"."User Journal Source Name" saw_7, "General Ledger - Journals Real Time"."- Ledger"."Ledger Name" saw_8, "General Ledger - Journals Real Time"."- Line Details"."Line Currency Code" saw_9, "General Ledger - Journals Real Time"."- Line Details"."Line Description" saw_10, "General Ledger - Journals Real Time"."- Natural Account Segment"."Account Description" saw_11, "General Ledger - Journals Real Time"."- Lines"."Journal Line Accounted Amount Credit" saw_12, "General Ledger - Journals Real Time"."- Lines"."Journal Line Accounted Amount Debit" saw_13, "General Ledger - Journals Real Time"."- Lines"."Journal Line Entered Amount Credit" saw_14, "General Ledger - Journals Real Time"."- Lines"."Journal Line Entered Amount Debit" saw_15 FROM "General Ledger - Journals Real Time" WHERE "- Line Details"."Line Period Name" IN ('ENE-17', 'FEB-17')

2. The parameters entered for Period Name are: 'ENE-17', 'FEB-17'
3. Show Results and the report will show the transactions for those periods, but it does not show the LE name (First column)

4. If the very same report is tested for 'ENE-15', 'FEB-15' the reports shows correctly.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot deliver the report as it is since it does not show the correct information all the time.

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
Cause
Solution
References


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