Hierarchy Node Issue in Allocation After Installing OFSAAI 7.3.5 (Doc ID 2023727.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 6.1.0.3, after upgrading to OFSAAI 7.3.5, when you create a new Allocation that references a Node value on a dimension hierarchy, the Node value is saved with a level of "0" instead of the correct level from the Hierarchy.

For example, on the Source screen, you set Organizational Unit to Node 9990001.  The following is displayed in the interface:

Org_Hier:OFSAASEG@Level ID: 0 For Node: 9990001-Operations

Additionally, in FSI_M_ALLOC_LEAF_SELECTION, HIERARCHY_LEVEL = 0 for the node value.  (If the node is on level 3 of the Hierarchy, the level should indicate "3".)

As a result of this issue, the Allocation is not finding any rows to process and the result is 0 rows output.

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