My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.