Unexpected Results for Some Instruments Using Relative Payment Pattern in BSP

(Doc ID 2358476.1)

Last updated on FEBRUARY 15, 2018

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.1.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Balance Sheet Planning (BSP)

Symptoms

On BSP 8.0.2.1.1, there appear to be 68 instruments which are not applying the payment pattern in the way it was intended.

ACTUAL BEHAVIOR
Out of 1,539 instruments, 68 instruments do not apply the payment pattern in the way it was intended.

Found one commonality between those instruments that applied the correct payment pattern and those that did not. The 68 instruments that did not correctly apply the payment pattern had an origination date of either 26-JUL-17 or 28-AUG-17 (as of date 30-SEP-17). None of the instruments that correctly applied the payment pattern had one of those two origination dates.

Have not been able to find any other fields that would explain the reason the 68 instruments would incorrectly apply the payment pattern.

Users reviewed the following fields and could not detect a pattern that could explain the issue:

NEXT_PAYMENT_DATE
LAST_PAYMENT_DATE
NEXT_REPRICE_DATE
LAST_REPRICE_DATE
AMRT_TERM
ORG_TERM
REMAIN_NO_PMTS_C
MATURITY_DATE
INTEREST_RATE_CD (all the same)
AMRT_TYPE_CD (all 11999, the payment pattern)
ADJUSTABLE_TYPE_CD (all the same)
ACCRUAL_BASIS_CD (all the same)
COMPOUND_BASIS_CD (all the same)
INT_TYPE (all the same)
PMT_FREQ (all the same)
PMT_FREQ_MULT (all the same)
REPRICE_FREQ (all the same)
REPRICE_FREQ_MULT (all the same)
CUR_PAYMENT

The issue can be reproduced at will with the following steps:
1. Define Payment pattern
2. Run calculate

Cause

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