Slow Performance of Ledger Stat to Instrument Allocation Using Percent Distribution in PA 4.5
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
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:
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;
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