Not All Tree Filters Migrated from OFSA 4.5 to OFSAA 6.0 After Running Hierarchy Migration (Doc ID 1669101.1)

Last updated on MAY 07, 2014

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 7.3/6.0, after trying to migrate Tree Filters from an Oracle Financial Services Applications (OFSA) 4.5 environment using the fsi_util.migrate_hierarchy program, not all Tree Filters are migrated successfully.  When you compare row counts between the 4.5 table OFSA_IDT_VIEW_FILTER and the 6.0 table REV_HIERARCHY_FILTER, you find that REV_HIERARCHY_FILTER contains fewer rows.  Not all Tree Filters listed in OFSA_IDT_VIEW_FILTER are migrated into the target OFSAA 6.0 environemnt.

OFSA 4.5: select count(*) from ofsa_idt_view_filter;

OFSAA 6.0: select count(*) from rev_hierarchy_filter;

Additionally, if you check the hierarchy rows in the OFSAA 6.0 table FSI_M_OBJECT_DEFINITION_B, you find that the number of rows matches the count from the source 4.5 table OFSA_IDT_VIEW_FILTER.

select count(*) from fsi_m_object_definition_b where table_name = 'REV_HIERARCHY_FILTER';

You do not understand why data is missing from REV_HIERARCHY_FILTER for some of the OFSA 4.5 Tree Filters.

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