Fusion Financials GL OTBI: Data incorrect for "Subledger Accounting - Journals Real Time" Accounted Amount CR/DR, multiplied by 4 (Doc ID 1994897.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.1.5.1 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Symptoms

Fusion Financials Cloud 11.1.8 - custom analysis, the column "Journal Line Accounted Amount DR" value is multiplied by 4

Unexpected behavior
----------------------------------

Data Value is incorrectly multiplied  * 4 compared to the Fusion screen " Inquire and Analyze Balances - Account Inspector"

Transaction Number 33333 , Invoice Line 1, amount is 1,500.00

In OTBI analysis, Invoice 33333 - Journal Line 1, Amount is 6000.00 ie multiplied by 4


Same behavior for simplified version of this analysis - select any one dimension column at the Journal *Line* level,  and  the fact column "Journal Line
Accounted Amount DR".

Steps:
-----------
Create and run the following custom analysis:


SELECT
  0 s_0,
  "Subledger Accounting - Journals Real Time"."- Header Information"."Invoice Number" s_1,
  "Subledger Accounting - Journals Real Time"."Cost Center"."Cost Center Code" s_2,
  "Subledger Accounting - Journals Real Time"."GL Account"."Account Type" s_3,
  "Subledger Accounting - Journals Real Time"."Natural Account"."Account Code" s_4,
  "Subledger Accounting - Journals Real Time"."Time"."Fiscal Period Number" s_5,
  "Subledger Accounting - Journals Real Time"."Time"."Fiscal Period" s_6,
  SORTKEY("Subledger Accounting - Journals Real Time"."Time"."Fiscal Period") s_7,
  "Subledger Accounting - Journals Real Time"."Journals"."Journal Line Accounted Amount CR" s_8,
  "Subledger Accounting - Journals Real Time"."Journals"."Journal Line Accounted Amount DR" s_9
FROM "Subledger Accounting - Journals Real Time"
WHERE
(("Natural Account"."Account Code" = '62020') AND ("Cost Center"."Cost Center Code" = '1420'))
ORDER BY 1, 5 ASC NULLS LAST, 3 ASC NULLS LAST, 2 ASC NULLS LAST, 6 ASC NULLS LAST, 8 ASC NULLS LAST, 4 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms