My Oracle Support Banner

FAQ of OFSA 4.5 Allocation Performance Issues (Doc ID 269436.1)

Last updated on FEBRUARY 12, 2020

Applies to:

Oracle Profitability Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Note: All OFSA 4.5 products have reached sustaining support.


This troubleshooting guide is a collection of Notes created to assist in the troubleshooting of performance issues seen when processing a Performance Analyzer Allocation ID. Oracle Performance Analyzer is part of the Oracle Financial Services Applications (OFSA). The product has been renamed as Oracle Profitability Manager.

For details on what information may be requested by support to assist in troubleshooting an Allocation Performance issue, please see Note: 208139.1 Troubleshooting Slow Performance Allocation IDs in OFSA 4.5.

Questions and Answers

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
Questions and Answers
 How to references:
 Allocations Total Process Time Longer than SQL Trace Execution Time
 Slow Performance of Ledger Stat to Instrument Allocation Using Percent Distribution
 Allocation Using %Distr-Leaf on Instrument Table Runs Slow or Hangs in 4.5 or Returns Signal -11 Error
 Allocation Running Slowly Due to Full Table Scan
 Single Pass Allocation Hanging
 Slow Performance on Ledger to Ledger Allocation Performing Calculation
 Allocation Performance Slow - COMMON_COA_ID Set to One Value
 Performance Problems With Transaction To Instrument Table Allocations
 Allocation Using Table ID Performing Slow
 Full Table Scan on Temp Table for Ledger to Ledger Allocations

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