My Oracle Support Banner

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

Last updated on MARCH 01, 2019

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)


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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.