Slow Performance of Adjustment Processes in FTP 6.1
Last updated on AUGUST 21, 2015
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 6.1 to 188.8.131.52 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms