OFSAA Partial Data Transfer In ALM BI Transformation (Doc ID 2025574.1)

Last updated on JUNE 29, 2015

Applies to:

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

Symptoms

On ALMBI 6.0, it appears that the ALMBI Transformation is only moving a small number of records into the fact agg base ccy cashflows table.

ACTUAL BEHAVIOR
For the last 3 days OFSAA ALM data processing only 10% data is getting transferred into fact agg base ccy cashflows table via the BI transformation. So data of ledger stat and other instrument tables is not available in the reports. Even though the batch completes successfully, incorrect number of records appears to load.

Load Successful  FCT_AGG_BASE_CCY_CASHFLOWS for  RES_DTL_201071 Record Count 12950
Deterministic Process Initiated
Fact Table Data Deleted . Rerun Flag is Enabled
Loading Started for 200460 for table RES_DTL_200460 for Financial Element Type 1
Building the Query block   RES_DTL_200460  FOR  200460
Load Successful  FCT_AGG_BASE_CCY_CASHFLOWS for  RES_DTL_200460 Record Count 865550 <= wrong number of records

EXPECTED BEHAVIOR
Normally about 900000 records are transferred but for last 3 days processing only 90000 odd records are available in fact agg base ccy cashflows.

The issue can be reproduced at will with the following steps:
1. Run ALM BI Transformation

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