My Oracle Support Banner

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 APRIL 24, 2023

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.