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

Symptoms

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms