My Oracle Support Banner

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

Last updated on SEPTEMBER 29, 2023

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Business Intelligence Enterprise Edition (OBIEE)
OBIEE Repository Database (RPD)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI)


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.


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

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