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

Last updated on JULY 28, 2017

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.

Symptoms

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;

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