FTP Matched_Spread_C is Incorrectly Updated During FTP Remaining Term Processing (Doc ID 1909109.1)

Last updated on DECEMBER 09, 2016

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Funds Transfer Pricing (FTP) 6.1.0.3, matched_spread_c is incorrectly updated when selecting Remaining Term in Calculation for processing.

ACTUAL BEHAVIOR

Standard Term selected:
Cur_Net_Rate = 5
Transfer_Rate = 2.5
Matched_Spread_C = 2.5 (Cur_Net_Rate - Transfer_Rate)
Tran_Rate_Rem_Term = 0
 
Remaining Term selected:
Cur_Net_Rate = 5
Transfer_Rate = <not updated>
Matched_Spread_C = .025 <= Incorrect
Tran_Rate Rem_Term = .995
 
EXPECTED BEHAVIOR

Expect Matched_Spread_C to only be calculated for Standard Term.

The issue can be reproduced at will with the following steps:

1. Run FTP process using Standard Calculation Mode
2. Rerun FTP process using Remaining Term Calculation Mode
3. Check calculated Matched_Spread_C

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