Data Not Getting Populated to FCT_MGMT_REPORTING Table for EFPA Reporting
(Doc ID 2548311.1)
Last updated on OCTOBER 07, 2019
Applies to:Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
Oracle Financial Services Enterprise Performance Management (EPM)
On 8.0.5 version, database function FN_MGMT_REP_MGMT_LEDGER_TRM is executed successfully, however there are no values populated in FCT_MGMT_REPORTING table from FSI_D_MANAGEMENT_LEDGER, for usage by the seeded EFPA Dashboard.
FCT_MGMT_REPORTING was expected to be populated with Income Statement and Balance Sheet.
Income Statement values (ex. Non-Interest Income, Non-Interest Expense, etc.), having source_type = 100 in FSI_DATA_IDENTITY, are calculated by an Allocation before hand.
Balance Sheet rows are from data loaded into Management Ledger (original source) which has a source_type = 0 in FSI_DATA_IDENTITY.
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
- Run database function FN_MGMT_REP_MGMT_LEDGER_TRM.
- Check if FCT_MGMT_REPORTING table is populated.
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