FTP 8.0.5 Processing Slow Performance Issue
(Doc ID 2856309.1)
Last updated on SEPTEMBER 23, 2022
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 to 8.0.6 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)
On FTP 8.0.5, all FTP engine batches are running abnormally slow during production processing. All standard batches that normally run in 10-15 minutes are taking more than 2-3 hours. The slowness is not tied to a specific product, FTP process, or instrument table (appears to be widespread).
Other tasks like SQL Rules are running in expected times.
DBA gathered schema stats and recycled server and services but the performance issue continues.
DBA is not seeing any issues with network/server or database performance.
Issue seems to have appeared after applying non related Break Identification patches (not FTP engine patches):
- FTP 22.214.171.124.33 FTP FTP-126.96.36.199.33 One-Off Patch <Patch 32593975> - BREAK IDENTIFICATION PROCESS SCREEN FAILS TO RENDER IN THE UI
- FTP 188.8.131.52.34 FTP FTP-184.108.40.206.34 One-Off Patch <Patch 32603617> - RELATIONAL DATA FILTER CAUSES PARTIAL BREAK IDENTIFICATION TO FAIL WITH ORA-00933
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