My Oracle Support Banner

Slow Performance of Ledger Stat to Instrument Allocation Using Percent Distribution in PA 4.5 (Doc ID 293092.1)

Last updated on MARCH 18, 2019

Applies to:

Oracle Profitability Manager - Version 4.5 to 4.5.41
Information in this document applies to any platform.
Oracle Performance Analyzer - Version: 4.5
Allocation ID

Note: All OFSA 4.5 products have reached sustaining support.


A percent distribution Allocation ID that moves records from LEDGER_STAT to an instrument table or transaction table runs slowly or hangs.

The records retrieved from LEDGER_STAT by the "Filter On" criteria include multiple values for the Leaf Field(s) used to slice the data into "units of work".  For example, if you use COMMON_COA_ID to slice the data, the "Filter On" records will contain several different COMMON_COA_ID values.

To determine which Leaf field you use to slice data into "units of work" for allocations, run the following query:

select ds.column_name, ds.process_data_slices_cd
from ofsa_process_id_step_run_opt ro, ofsa_process_data_slices_dtl ds
where ds.process_data_slices_cd = ro.process_data_slices_cd
and ro.sys_id_num = 0;


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.