0 Records Loaded into ALMBI Fact Tables When Running ALM_BI_TRANSFORMATION Release 8.0.x (Doc ID 2206107.1)

Last updated on NOVEMBER 21, 2016

Applies to:

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

Symptoms

On : 8.0.1 version, PLSQL SCRIPTS

When you run the ALM_BI_TRANSFORMATION program, no data is moved from the ALM Result Detail tables into the ALMBI "FCT_" tables.

Error:
FSI_MESSAGE_LOG shows it attempted to load data but zero rows were loaded.

Deterministic Process Initiated
Fact Table Data Deleted . Rerun Flag is Enabled
Loading Started for 200260 for table RES_DTL_200260 for Financial Element Type 1
Building the Query block RES_DTL_200260 FOR 200260
Load Successful FCT_AGG_BASE_CCY_CASHFLOWS for RES_DTL_200260 Record Count 0
Loading Started for 200260 for table RES_DTL_200260 for Financial Element Type 2
Building the Query block RES_DTL_200260 FOR 200260
Load Successful FCT_AGG_BASE_CCY_LR_GAP for RES_DTL_200260 Record Count 0
Loading Started for 200260 for table RES_DTL_200260 for Financial Element Type 3
Building the Query block RES_DTL_200260 FOR 200260
Load Successful FCT_AGG_BASE_CCY_IRR_GAP for RES_DTL_200260 Record Count 0
Loading Started for 200260 for table CONS_DTL_200260 for Financial Element Type 1
Building the Query block CONS_DTL_200260 FOR 200260
Load Successful FCT_AGG_CONS_CCY_CASHFLOWS for CONS_DTL_200260 Record Count 0
Loading Started for 200260 for table CONS_DTL_200260 for Financial Element Type 2
Building the Query block CONS_DTL_200260 FOR 200260
Load Successful FCT_AGG_CONS_CCY_LR_GAP for CONS_DTL_200260 Record Count 0
Loading Started for 200260 for table CONS_DTL_200260 for Financial Element Type 3
Building the Query block CONS_DTL_200260 FOR 200260
Load Successful FCT_AGG_CONS_CCY_IRR_GAP for CONS_DTL_200260 Record Count 0
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

Steps:
1. ALM Process executed successfully and RES_DTL_200260 populated.
2. Hierarchy Transformation was successful and REV_HIER_FLATTENED populated.
3. SCDs have been run successfully.
4. DIM_RUN and DIM_DATES have been run successfully
6. No error in FSI_MESSAGE_LOG
7. No error message in $FIC_DB_HOME/log/date/DT_ nor RUN_ logs.

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