Not All Tree Filters Migrated from OFSA 4.5 to OFSAA 6.0 After Running Hierarchy Migration
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)
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.
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