My Oracle Support Banner

How to Merge Asset Liability Management and Funds Transfer Pricing Data Models (Doc ID 1085672.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 5.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 5.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Information in this document applies to any platform.


This note describes how to merge Oracle Financial Services Asset Liability Management(OFSALM) 5.1 and Funds Transfer Pricing(FTP) 5.1 data models and generate one model. The subject areas that are present in FTP and not present in OFSALM will be compared. As a result of this exercise, OFSALM model will contain all the FTP related entities.

The purpose of this document,OFSALM data model that was released on Linux platform is taken as the base. OFSALM data model on AIX platform had additional columns TRANS_ID and TRUE_GL_ID in the instrument and result tables. This was subsequently removed during the Linux platform qualification release.

Steps to merge data model with in AIX:
  • Go to Fusion - ALM Client Tables Subject Area for each table and remove TRANS_ID and TRUE_GL_ID columns from tables below:
  • Go to Fusion - Ledger Stat Subject Area and remove TRANS_ID and TRUE_GL_ID from the LEDGER_STAT table.
  • Go to Fusion - Instrument - Annuity Contracts Subject area and remove TRANS_ID and TRUE_GL_ID from the LEAF_COLUMNS super-type table. This will remove TRANS_ID and TRUE_GL_ID from all the instrument tables.


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

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