My Oracle Support Banner

Is It Possible to Exclude Interest Calculation (FE 430, FE 440 & FE 1672) from RES_DTL Table? (Doc ID 2571158.1)

Last updated on JULY 30, 2019

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 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

Question 1: Is there a way of excluding calculation of interest (FE 430), accrued interest (FE 440) and Liquidity Gap Interest Cash Flow Net (FE 1672) from RES_DTL_XXXXXX table?
 
Question 2: This query is for Non Performing Loan Accounts, no Behaviour Pattern is being used for these cases.
In given implementation, it is supposed to bucket Non Performing Loans cash flows based on different assumptions provided by business.

For example:
Requirement was to bucket all Retail NPLs in 2 year to 3 year Bucket. (MISDATE - 31-Jan-2019). To meet this requirement, data is being loaded in FSI_D_LOAN_CONTRACTS using AMRT_TYPE_CD = 700 and MATURITY_DATE = 31-Jan-2022.
As a result for Principal and Interest Cash Flows for such cases is getting calculated for non Performing Loans.

Is there a way to restrict generation of Interest Cash Flows using "Calculation Elements" or any other parameter Screen?
 
Question 3: Bank has very specific requirements based on various other parameters like party and product for bucketing logic of respective NPLs. These conditions cannot be filtered out using Behaviour Pattern.
For ex. Bank wanted Retail NPLs and Corporate NPLs to be plotted in different buckets. How can we meet this requirement using Behaviour Pattern.

Even if Behaviour Pattern is used, still interest gets calculated if the account has cur_net_rate. Behaviour Pattern is used for CASA products and interest is correctly being calculated by system as per defined Behaviour Pattern.

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!


In this Document
Goal
Solution


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