ALM Tier Accounts Is Not Considering the Accrued Interest Provided at the Account / Instrument Level for FE 430 Interest Cash Flow (Doc ID 3030893.1)

Last updated on JUNE 26, 2024

Applies to:

Symptoms

On ALM 8.1.2.2, it appears that Tier Accounts is not considering the Accrued Interest provided at the account level.

Currently processing the Tier Rate accounts by populating the account Rate tires in the FSI_D_ACCOUNT_RATE_TIERS tables and populating the adjustable type cd as 300 for the account level data in the fsi_D_loan_contracts.
Interest Cash flows are getting generated using the Rate tiers and balances.  However, it is not considering the accrued interest amount provided at the account level data in fsi_d_loan_contracts.accrued_interest column.
Since one tier accounts might have different rate tiers fixed/floating. The accrued interest should be considered from the source system till the processing date.

Have also tried to populate the accrued interest for each tier in the fsi_d_account_rate_tiers.accrued_interest.
Now the accrued interest is added to the first interest cash flows.  However, it seems that the same accrued interest is again added to the subsequent cash flows each time the FE 430 Interest Cash Flow is calculated instead of just first time to account for Interest between last payment date (LPD) and as of date (AOD).

EXPECTED BEHAVIOR
Expect that fsi_d_loan_contracts.accrued_interest amount be considered for FE 430 interest cash flow results for the first interest cash flow date only.

Changes

Cause

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