PA 4.5 Allocation Performance Slow - Unit of Work Contains One Value
Last updated on JULY 28, 2017
Applies to:Oracle Profitability Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5.39
Oracle Performance Analyzer - Version: 4.5 to 4.5.39
Note: All OFSA 4.5 products have reached sustaining support.
In Oracle Performance Analyzer (PA) 4.5.39, an Allocation ID's performance is slow. The Allocation ID may appear to hang.
The unit of work leaf column(s) defined for multiprocessing (ex. Common COA ID) only contains one value in the Filter On data.
To determine the unit of work column(s) used by the Allocation engine, run the following query:
from ofsa_process_id_step_run_opt a, ofsa_process_data_slices_dtl b
where a.process_data_slices_cd = b.process_data_slices_cd
and a.sys_id_num = 0;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms