My Oracle Support Banner

Full Break Detected in FTP Despite No Change In Cur Par Balance Between Prior And Current Day (Doc ID 2967377.1)

Last updated on AUGUST 21, 2023

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Modern Risk and Finance (MRF)

Goal

On FTP 8.0.x, you found that for one mortgage, Type-1 (Full break) is getting generated but there is no change in Cur Par Balance between prior and current day record.

In FSI_D_BREAK_FUNDING_CHARGES table:

AS_OF_DATE = 1-Jul-23 and
NEXT_PAYMENT_DATE = 7-Jul-23.
BREAKAGE_TYPE_CD = 1
BREAKAGE_AMOUNT = 4603.95
CUR_PAR_BAL = 4603.95

From Mortgage instrument table:

ADJUSTABLE_TYPE_CD = 250
CUR_PAR_BAL = 4603.95

From Break Identification process definition, Parameters screen has:

- Full break & Partial break, both checked.
- Prior period reference term: 1 Days
- As of Date: 06/06/2021
- Prior Period Date: 06/05/2021

You are using filter on Adjustable Type Code and, when Adjustable Type Code changes from Fixed to Floating between prior and current day, system detects this wrongfully as Type-1 break using NOT EXISTS condition between prior and current day.

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.