My Oracle Support Banner

Questions on 8.1 Data Model Merge Differences for ALM and FSDF (Doc ID 2768128.1)

Last updated on APRIL 26, 2021

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Data Foundation (FSDF)


Goal

On 8.1.0.0.0 version, while attempting to merge FSDF model with ALM in Erwin data modeler, noticed items mentioned below. Are these differences okay and is model merge exercise good or do these items need to be addressed?
 
Question 1: FSDF model has N_REGION_SKEY index for DIM_COUNTRY  but ALM model does not. FSDF has Relationship with DIM_REGION but ALM does not. Which one should be used?

Question 2: Several FSI_D_XXX tables were moved from ALM to FSDF as part of the merge, but they are still showing differences under relationships for Key Group Filter.

Question 3: FSI_IRC_TS_PARAM_HIST Indexes and relationship on ALM Model side has not moved to FSDF.

Question 4: Even though relationships have moved for FSI_IRCS, it still shows the two items as different.

 

Solution

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
Goal
Solution
References


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