OFSAA Partial Data Transfer In ALM BI Transformation
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)
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.
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
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
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