Notice Final FE 430 Maturity Date Different Than Expected (Doc ID 413206.1)

Last updated on FEBRUARY 14, 2007

Applies to:

Oracle Risk Manager - Version: 4.5.2 to 4.5.39
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)

Goal

Users notice that their FE 430 value has a different maturity date than expected.  They notice the loan pays off at maturity date.  The instrument record has the following characteristics:

AS_OF_DATE = 30-Nov-06
AMRT_TERM = 121
AMRT_TERM_MULT = M
AMRT_TYPE_CD = 100
MATURITY_DATE = 1-Feb-14
NEXT_PAYMENT_DATE = 1-Dec-06
PMT_FREQ = 1
PMT_FREQ_MULT = M
REMAIN_NO_PMTS_C = 3
CUR_BOOK_BAL = 69249.24
CUR_PAYMENT = 23586

Users see the following in the OFSA_PROCESS_CASH_FLOWS:

 

FINANCIAL_ELEM_ID ID_NUMBER CALC_SOURCE_CD ISO_CURRENCY_CD CASH_FLOW_DATE CASH_FLOW_CD FLOAT_VALUE

210 2101269000500001859978 0 INR 12/1/2006 2 23,239.25
210 2101269000500001859978 0 INR 1/1/2007 2 23,286.72
210 2101269000500001859978 0 INR 2/1/2014 2 22,723.27
430 2101269000500001859978 0 INR 12/1/2006 2 750.777177
430 2101269000500001859978 0 INR 1/1/2007 2 498.824948
430 2101269000500001859978 0 INR 2/1/2014 2 20566.93086 <==Here 

Users felt the loan should have paid off in February 2007, but the OFSA_PROCESS_CASH_FLOWS and RES_DTL table is showing a maturity of 1-Feb-14 and they want to know why.

 

Solution

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