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 AUGUST 16, 2018

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)

Goal

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.

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.