Intermediary Table FSI_TP_CATERPILLAR_INTRMDIATE for Caterpillar FTP Method Writing Rates Incorrectly Divided By 100
(Doc ID 2986887.1)
Last updated on NOVEMBER 20, 2023
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 Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Funds Transfer Pricing (FTP)
Interest Rate Code (IRC) / Yield Curve
On FTP 18.104.22.168, it appears that in the intermediary table of the Caterpillar FTP method, FSI_TP_CATERPILLAR_INTRMDIATE, the rates are being written divided by 100.
Have noticed that in the intermediary table of the Caterpillar FTP method the rates are being written divided by 100. For example, if the rate on the IRC is 0.123456, the rate in the caterpillar table is being written as 0.001234. If there would be an initial processing when only initial strips are originating, the rate written back on account level would be correct because the engine even if it is writing in the caterpillar table the rate as divided by 100, on instrument level it is writing the rate correctly undivided by 100 with the exact decimals as picked up from the IRC, as in this example 0.123456.
The issue is that in the second processing when the engine is blending the FTP rates between old un-matured and new strips, the FTP rate of the old strips is used as divided by 100 which is losing the correct precision of those FTP rates. For example, if the rate should have been 0.123456 but the engine is using it as 0.001234 when blending, the last two digits are being lost.
Expect that the FTP rates in the intermediary table of Caterpillar are calculated in percentage format, just like all other FTP methods are writing results.
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