0 Records Loaded into ALMBI Fact Tables When Running ALM_BI_TRANSFORMATION (Doc ID 1501746.1)

Last updated on MARCH 18, 2016

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Asset Liability Management Analytics (ALMBI), when you run the ALM_BI_TRANSFORMATION program, no data is moved from the ALM Result Detail tables into the ALMBI "FCT_" tables.  In FSI_MESSAGE_LOG, there are messages indicating it attempted to load data but zero rows were loaded:

Deterministic Process Initiated
Loading Started for 210743 for table RES_DTL_210743 for Financial Element Type 1
Building the Query block RES_DTL_210743 FOR 210743
Load Successful FCT_AGG_BASE_CCY_CASHFLOWS for RES_DTL_210743 Record Count 0
Loading Started for 210743 for table RES_DTL_210743 for Financial Element Type 2
Building the Query block RES_DTL_210743 FOR 210743
Load Successful FCT_AGG_BASE_CCY_LR_GAP for RES_DTL_210743 Record Count 0
Loading Started for 210743 for table RES_DTL_210743 for Financial Element Type 3
Building the Query block RES_DTL_210743 FOR 210743
Load Successful FCT_AGG_BASE_CCY_IRR_GAP for RES_DTL_210743 Record Count 0
 Warning: No Financial Element Present in cons_dtl_210743 for CF Results
 Warning: No Financial Element Present in cons_dtl_210743 for LR
 Warning: No Financial Element Present in cons_dtl_210743 for IRR
Number of Rows Inserted Into FCT_AGG_BASE_CCY_ALM_MEASURES:0
Number of Rows Inserted Into FCT_AGG_CONS_CCY_ALM_MEASURES:0
Number of Rows Inserted Into FCT_FCST_INTEREST_RATES:0
Number of Rows Inserted Into FCT_FCST_EXCHANGE_RATES:0
number of rows inserted into fct_fcst_eco_ind:0
started loading cash flows
Number of Rows Inserted Into FCT_PROCESS_CASHFLOW:0
Process Completed Successfully


As a result, no rows exist in the FCT_ tables like FCT_AGG_BASE_CCY_CASHFLOWS and FCT_AGG_BASE_CCY_IRR_GAP and the ALMBI Dashboards have no results to display.  The ALM Results Transformation cannot be completed.

Cause

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