Allocation with Large Table ID and Large Hierarchy Filter Hangs (Doc ID 1555890.1)

Last updated on MAY 23, 2013

Applies to:

Oracle Financial Services Profitability Management - Version 5.6 to 6.0.2 [Release 5 to 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 5.6 version, Calculation Engine

When attempting to run Static Table Driver Allocation with large Table ID (about 10,000 rows) and Hierarchy Filter (about 1800 rows selected), the process hangs.

ofspa debug log ends with a long list of node selectsions on OFSA_IDT_ROLLUP:

FROM    OFSA_IDT_ROLLUP
WHERE    OFSA_IDT_ROLLUP.sys_id_num = 200021
and    (OFSA_IDT_ROLLUP.node_02 = 1010000
or    OFSA_IDT_ROLLUP.node_02 = 1300000
or    OFSA_IDT_ROLLUP.node_02 = 1400000))
...etc a long list of selections    
and    a.year_s IN (1999)
AND    a.CONSOLIDATION_CD = 100

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