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

Last updated on AUGUST 21, 2015

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

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 hundreds of Community platforms