Hierarchy Node Issue in Allocation After Installing OFSAAI 7.3.5
Last updated on OCTOBER 12, 2016
Applies to:Oracle Financial Services Profitability Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Profitability Management (PFT) 220.127.116.11, 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.
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