My Oracle Support Banner

Troubleshooting Slow Performance Issues in Funds Transfer Pricing (FTP) Process (Doc ID 2458168.1)

Last updated on OCTOBER 11, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Purpose

The purpose of this document is to provide steps to diagnose slow performance issue for Funds Transfer Pricing (FTP) process. Cash Flow Engine executes defined assumptions and generate rates. The steps below list items to check to identify the source of the performance issue.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 1. Verify there are no issues with tables and indexes used in the process
 2. Verify there is no locked objects
 3. Verify there is no hang shared memory
 4. Verify Audit Option is not selected
 5. Correct FTP Process errors

 6. Request further assistance to troubleshoot
 a. Provide details of the specific batch/task that run slow
 b. Provide timing of the slow running tasks
 c. Provide ofstp debug output
 d. Provide AWR Workload Repository report
 e. Generate an Execution Plan for the long running SQL
 f. Provide Tuning Option¬†
References

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