My Oracle Support Banner

Slow Performance of Adjustment Processes in FTP 6.1 (Doc ID 1593276.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1 to 6.1.0.1 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After installing Oracle Financial Services Funds Transfer Pricing (FTP) 6.1, FTP Processes that contain Adjustment rules are running slowly.  For example, a process that calculates the Transfer Rate may run in 1 minute.  But a process that performs an Adjustment on the same data takes 15 minutes to run.  Additionally, if you upgraded to version 6.1 from an earlier version, the Adjustment processes ran much faster in that earlier version.

You observe that the SQL may be doing a row by row update.  You think this behavior may cause the slow performance.

Cause

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
Symptoms
Cause
Solution
References


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