My Oracle Support Banner

FAW CAA - Configurable Account Analysis - Wrong Journal Line Debit/Credit Amounts in the UI (frontend) (Doc ID 2978986.1)

Last updated on OCTOBER 13, 2023

Applies to:

Fusion Analytics Warehouse - Version 23.R3.x and later
Information in this document applies to any platform.

Symptoms

Following Configurable Account Analysis transition, previous analysis do not behave the same. The previous report is missing data values (some data not all) for the following columns in his ledger:

- Journal Debit Amount (Entered)
- Journal Credit Amount (Entered)
- Journal Debit Amount (Accounted)
- Journal Credit Amount (Accounted)

On the other hand, if running the same query from OAX_user (as the same ADMIN ) all values are being displayed.

Basically this makes the report showing a sum value being inconsistent because of the missing per column.


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


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