FTP Adjustment Propagation is Updating Additional Columns When Used On User Defined Fields
Last updated on OCTOBER 04, 2016
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 220.127.116.11 and later
Information in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
On FTP 18.104.22.168, it appears that rates are being incorrectly propagated when used in conjunction with an alternate rate output mapping rule.
After running FTP process, it has propagated rates correctly to the XIB_PIP_LIQUIDITY_RATE column as expected, but also calculated the other adjustment rate which is not expected since there is an alternate rate output mapping rule defined which means results should be populated in XIB_PIP_LIQUIDITY_RATE column for the contracts which has not been propagated.
Rate should only be calculated in XIB_PIP_LIQUIDITY_RATE.
The issue can be reproduced at will with the following steps:
1. TP Standard Process has Adjustment Rule and Alternate Rate Output defined.
Adjustments is selected
Adjustment Propagation is selected
Alternate Rate Output is selected
Mortgages Full term view
Adjustment Type Selection: Other Adjustments ****
MBEEE_MO_Fixed Mortgages - Adj Method: Fixed Rate
Reference Term: Original Term
Alternate Rate Output Mapping Rule:
Transfer Rate: Transfer Rate
Matched Spread: Matched Spread
Remaining Term Transfer Rate: Remaining Term Transfer Rate
Other Adjustment Rate: Pipeline Liquidity Rate
Other Adjustment Amount: Other Adjustment Amount
2. Run the TP Process
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