Slow Performance on Ledger to Ledger Allocation Performing Calculation
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.
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