How to Upgrade FSDW 5.6 to FSDF 7.4 Including Data Model Changes (Doc ID 1629429.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Data Foundation - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Data Warehouse (FSDW)
Oracle Financial Services Data Foundation (FSDF)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Goal

You plan to upgrade existing FSDW 5.6 (OFSAAI 7.2) to FSDF 7.4.  While checking upgrade steps, the following questions arise:


Question 1. How to upgrade existing data model FSDF 5.6 + customized model to FSDF 7.4? You see in 7.4 data model that existing Subject Area name changed:

Example:
5.6 Name – ALM BI - Aggregate Base Currency EAR
7.4 Name - ALMBI - Fact Aggregate Base Currency EAR

 Almost 80% names have changed.  How to do upgrade and Erwin model merge?

Question 2. Can you upgrade directly from FSDW 5.6 to FSDF 7.4?

Solution

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