EFPA: How are FCT_MGMT_REPORTING Balance Columns Populated (Doc ID 2299278.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

EFPA 8.0.4.0.3.

What balance columns are populated in FCT_MGMT_REPORTING for Enterprise Financial Perfomance Analytics (EFPA) purpose?
During FCT_MGMT_REPORTING table load for EFPA, observed that only N_MOVEMENT and N_MOVEMENT_RCY columns being populated with the balance values from management ledger.
In the EFPA reporting there other measures which are also referring to other balance amounts, how are these columns being populated?

N_EOP_BAL
N_EOP_BAL_RCY
N_AVG_BAL
N_AVG_BAL_RCY
N_EOP_BAL_LCY
N_AVG_BAL_LCY
N_REG_CAP_ADJ_EOP_BAL
N_REG_CAP_ADJ_EOP_BAL_LCY
N_REG_CAP_ADJ_EOP_BAL_RCY
N_ECO_CAP_ADJ_EOP_BAL
N_ECO_CAP_ADJ_EOP_BAL_LCY
N_ECO_CAP_ADJ_EOP_BAL_RCY
N_REG_CAP_ADJ_AVG_BAL
N_REG_CAP_ADJ_AVG_BAL_LCY
N_REG_CAP_ADJ_AVG_BAL_RCY
N_ECO_CAP_ADJ_AVG_BAL
N_ECO_CAP_ADJ_AVG_BAL_LCY
N_ECO_CAP_ADJ_AVG_BAL_RCY
N_REG_CAP_ADJ_MOVEMENT
N_REG_CAP_ADJ_MOVEMENT_LCY
N_REG_CAP_ADJ_MOVEMENT_RCY
N_ECO_CAP_ADJ_MOVEMENT
N_ECO_CAP_ADJ_MOVEMENT_LCY
N_ECO_CAP_ADJ_MOVEMENT_RCY
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms