My Oracle Support Banner

Issue Merging 8.1 PFT Data Model Relationship Into 8.1 FTP Data Model (Doc ID 2772819.1)

Last updated on MAY 14, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Funds Transfer Pricing - 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 Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP

Symptoms

When installing both Oracle Financial Services Profitability Management (PFT) and Funds Transfer Pricing (FTP), you cannot merge the 8.1 PFT and FTP data models in Erwin.  There is an issue when merging the Transaction (TXNS) tables (ex. Fsi_D_Annuity_Txns) Relationship.

In Erwin Data Modeler, in the Complete Compare screen, as a first step, you merge the Trans_Leaf_Columns super class type table from the PFT Model into the FTP Model.  This is successful.  However, when attempting to merge the TXNS tables, the Relationship fails to merge.  When you try to add it, nothing happens.

Also in Complete Compare, under Entity/Table > Relationships, the Relationship Trans_Leaf_Column Is_a_Transaction_Leaf_Columns Fsi_D_Annuity_Txns is listed.

When you highlight the relationship, it lists the following:

Property View: Key Group not equal to XPKTransaction_Leaf_Columns [Filtered]

However, you also cannot add this value to the FTP Model.

You followed the steps in the "OFSAA Data Model Document Generation Technical Paper" but you still have the same issue.

Cause

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
Symptoms
Cause
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.