New Business Balances are 1.00 in FLOAT_VALUE Column in FSI_O_PROCESS_CASH_FLOWS (Doc ID 1456547.1)

Last updated on SEPTEMBER 17, 2016

Applies to:

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

Symptoms

In Oracle Financial Services Asset Liability Management (ALM), when you run a Dynamic Deterministic ALM process with "Detail Cash Flows" selected in the "Audit" screen, the balances output to the audit table FSI_O_PROCESS_CASH_FLOWS are wrong for the New Business data.  The new business rows output to FSI_O_PROCESS_CASH_FLOWS (with id_number = 999999) have FLOAT_VALUE = 1 for Financial Elements 100 (End Balance) and 195 (Maturity Runoff) among others.  You feel the FLOAT_VALUE should match the new origination balance created by the Forecast Balance rule.

The results are correct in the RES_DTL_XXXXX table.  There are New Business rows with RESULT_TYPE_CD = 1 that have valid balances for Financial Elements 100 and 195.  The incorrect amounts are only output to FSI_O_PROCESS_CASH_FLOWS.

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