Hierarchy Nodes Not Displaying in Existing Hierarchy After Applying OFSAAI 7.3.5.1

(Doc ID 2025555.1)

Last updated on APRIL 29, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5.1.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After applying the Patch 20527601 OFSAAI 7.3.5.1, none of the hierarchy nodes for existing hierarchies and copied hierarchies are displaying.



ACTUAL BEHAVIOR
Some of the hierarchies like legal entity and alt gl are appearing fine while in some like common COA and product have the nodes are all moved to Orphan nodes while in Org, none of the hierarchy structure is coming up at all.

EXPECTED BEHAVIOR
Expect the hierarchy to appear normally as loaded.

This was previously working in OFSAAI 7.3.5 before 7.3.5.1 was applied.

Additional finding:
Org and GL hierarchy is showing up on PFT Allocation but with no nodes, all leaf level details.
In Dimension Management, Org hierarchy is not showing any nodes while GL is showing all leafs under Orphan.

The issue can be reproduced at will with the following steps:
1. Master Maintenance -> Dimension Management -> Hierarchies
2. Open existing hierarchy

Changes

 Upgraded from 7.3.5 to OFSAAI 7.3.5.1.

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