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 18.104.22.168.0 and later
Oracle Financial Services Profitability Management - Version 22.214.171.124.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 126.96.36.199.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
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.
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