FCT_PROCESS_CASHFLOW not Populated by ALMBI Transformation

(Doc ID 1952608.1)

Last updated on JUNE 23, 2016

Applies to:

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

Symptoms

For ALMBI, after running successfully ALMBI transformation, though data reaches all others fact tables except for FCT_PROCESS_CASHFLOW table, from FSI_MESSAGE_LOG below is showing "Number of Rows Inserted Into FCT_PROCESS_CASHFLOW:0":

CONTEXT_SPECIFIC_TEXT
Deterministic Process Initiated
Fact Table Data Deleted . Rerun Flag is Enabled
Loading Started for 200555 for table RES_DTL_200555 for Financial Element Type 1
Building the Query block   RES_DTL_200555  FOR  200555
Load Successful  FCT_AGG_BASE_CCY_CASHFLOWS for  RES_DTL_200555 Record Count 7372
Loading Started for 200555 for table RES_DTL_200555 for Financial Element Type 2
Building the Query block   RES_DTL_200555  FOR  200555
Load Successful  FCT_AGG_BASE_CCY_LR_GAP for  RES_DTL_200555 Record Count 7760
Loading Started for 200555 for table RES_DTL_200555 for Financial Element Type 3
Building the Query block   RES_DTL_200555  FOR  200555
Load Successful FCT_AGG_BASE_CCY_IRR_GAP for RES_DTL_200555 Record Count 7760
Loading Started for 200555 for table CONS_DTL_200555 for Financial Element Type 1
Building the Query block   CONS_DTL_200555  FOR  200555
Load Successful  FCT_AGG_CONS_CCY_CASHFLOWS for CONS_DTL_200555 Record Count 6840
Loading Started for 200555 for table CONS_DTL_200555 for Financial Element Type 2
Building the Query block   CONS_DTL_200555  FOR  200555
Load Successful  FCT_AGG_CONS_CCY_LR_GAP for  CONS_DTL_200555 Record Count 7200
Loading Started for 200555 for table CONS_DTL_200555 for Financial Element Type 3
Building the Query block   CONS_DTL_200555  FOR  200555
Load Successful  FCT_AGG_CONS_CCY_IRR_GAP for  CONS_DTL_200555 Record Count 7200
Number of Rows Inserted Into FCT_AGG_BASE_CCY_ALM_MEASURES:1164
Number of Rows Inserted Into FCT_AGG_CONS_CCY_ALM_MEASURES:1080
Number of Rows Inserted Into FCT_FCST_INTEREST_RATES:41040
Number of Rows Inserted Into FCT_FCST_EXCHANGE_RATES:1444
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


The issue can be reproduced at with the following steps:

1. Execute a process and run ALMBI transformation.
2. Check FCT_PROCESS_CASHFLOW table.

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