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)
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:
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document