EFPA 8.0.7 Questions on Use of FCT_LEDGER_STAT Table (Doc ID 2873880.1)

Last updated on SEPTEMBER 29, 2023

Applies to:

Goal

Currently using the FCT_MGMT_REPORTING table as the main reporting table.  While examining the seeded Income Statement report: Dashboard - Financial Reporting-> Page – Income Statement there are two questions:

Question 1: In the OBIEE RPD, the Dim Reporting Line hierarchy uses the Dim GL Account table as opposed to DIM_REP_LINE, kindly clarify is this expected behavior?
It is expected that the Dim Rep Line table should be used instead.

Question 2: The fact data is coming from FCT Ledger Stat, ideally it should come from FSI_D_MANAGEMENT_LEDGER, as this the main ledger table.  Please advise how the out of the box reporting requirements can be met or is there any configuration that can be made to retrieve data from MGMT Ledger table.
 

Solution

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