Not All Selected Nodes and Leaves in Hierarchy Filter Do Not Appear in the REV_HIERARCHY_FILTER Table

(Doc ID 2412357.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
User Interface (UI)

Symptoms

OFSAAI 7.3.5.3, even after running the fn_hier_filter_sync_proc, there are missing leaf values which show in the UI which do not appear in the back end REV_HIERARCHY_FILTER table as expected.

 

The hierarchy is updated from Data Relationship Management (DRM).

Steps to reproduce

1. Navigate to Financial Services Applications -> Master Maintenance -> Filters
2. Open existing Hierarchy Filter and check backend REV_HIERARCHY_FILTER table

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