My Oracle Support Banner

Slow Performance on Ledger to Ledger Allocation Performing Calculation (Doc ID 242209.1)

Last updated on APRIL 14, 2009

Applies to:

Oracle Profitability Manager - Version: 4.5
This problem can occur on any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5


In Oracle Performance Analyzer (PA) 4.5, a Ledger Stat to Ledger Stat allocation that performs a calculation is running very slowly.  The performance is slow. 

The Allocation's "Filter On" selects rows containing many different unit of work values.

For example, the "Unit of Work" is Common COA ID.  The "Filter On" data processed contains 100 distinct Common COA ID values.  Looking at the OFSA SQL debug log, ofspa.xxxxx.log, the Allocation engine performs a sum of the Ledger Stat data for each distinct Common COA ID value.


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

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