Can the Performance of FTP Processing be Improved by Making the Engine Only Fetch IRC Data Used in Processed Instruments?
(Doc ID 2425982.1)
Last updated on MARCH 13, 2019
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.0.4 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)
Interest Rate Codes (IRC)
Is there a way to skip unnecessary IRC queries and reduce the time taken to complete a FTP process?
FTP process is taking a lot of time to complete when FSI_IRC_RATE_HIST table contains more than 10 million records.
It takes significantly long time even when processing against one instrument record only.
Example: Let's say instrument record is having interest_rate_cd = "1104".
Despite this aspect, as seen in ofstp log, the process is also looking for IRC data which is not used in the given process.
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