PA 4.5 Allocation Performance Slow - Unit of Work Contains One Value (Doc ID 183998.1)

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
Allocation ID
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

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:

select a.process_data_slices_cd, b.column_name, a.num_of_processes
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;

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