My Oracle Support Banner

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 MAY 24, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 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)


OFSAAI, 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


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

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