My Oracle Support Banner

How Does Accrued Interest Affect the Interest Cash Flow (FE 430) Calculation? (Doc ID 2386925.1)

Last updated on MAY 04, 2018

Applies to:

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

Goal

How is Interest Cash Flow (FE 430) being calculated when accrued_interest is populated?

After running an ALM process and validating the cash flow results in the FSI_O_PROCESS_CASHFLOWS table for below Term Deposit account:

For a certain account ID_NUMBER:

CUR_PAR_BAL CUR_NET_RATE ACCRUED_INTEREST
1000000        1.75               1486.3

It is assumed that the Interest Cash Flow (FE 430) was calculated as CUR_PAR_BAL * CUR_NET_RATE %:
1000000 * 1.75% = 17500

But the result generated in FSI_O_PROCESS_CASHFLOWS table is FE 430 = 19012.31025, so the ACCRUED_INTEREST was thought to be added to the calculation, which would have resulted in:
(1000000 * 1.75%) + 1486.3 = 18986.3

Neither calculations match the generated cash flow results however.  What is the correct way to validate FE 430 in such cases?

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.