EFPA 8.0.7 Questions on Use of FCT_LEDGER_STAT Table
(Doc ID 2873880.1)
Last updated on JUNE 07, 2022
Applies to:
Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.7 and laterInformation 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)
Reporting
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
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
Goal |
Solution |
References |