My Oracle Support Banner

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
Reporting
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

ACTUAL BEHAVIOR

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.

 

EXPECTED BEHAVIOR

FCT_MGMT_REPORTING was expected to be populated with Income Statement and Balance Sheet.

 

Note:

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:

  1. Run database function FN_MGMT_REP_MGMT_LEDGER_TRM.
  2. Check if FCT_MGMT_REPORTING table is populated.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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