1. Cash Flow Engine Reference Guide
  2. Cash Flow Dictionary
  3. Cash Flow Columns
  4. Maturity Date (MATURITY_DATE)
  5. Data Verification Requirements and Suggested Defaults

8.2.81.3 Data Verification Requirements and Suggested Defaults

  • For non-term accounts, MATURITY_DATE = AS_OF_DATE + 1 Day. If MATURITY_DATE defaults to 01-JAN-1900, the record's balance is not processed by Oracle ALM.
  • For term accounts, MATURITY_DATE is required.
  • If the record is not past due or defaulted, MATURITY_DATE > AS_OF_DATE.
  • MATURITY_DATE = ORIGINATION_DATE + ORG_TERM
  • MATURITY_DATE = AS_OF_DATE + REMAIN_TERM_C
  • MATURITY_DATE <= NEXT_PAYMENT_DATE + (REMAIN_NO_PMTS_C * PMT_FREQ).

Assume that MATURITY_DATE is less than NEXT_PAYMENT_DATE + (REMAIN_NO_PMTS_C * PMT_FREQ). This implies that an account's calculated Final Payment Date differs from MATURITY_DATE (the condition results in what is called a stub payment). In this case, the Cash Flow Engine forces the true last payment to be made on the maturity date. If condition 6 is not met (most likely caused because REMAIN_NO_PMTS_C is too low), the cash flow engine skips scheduled payments.