How to Merge Asset Liability Management and Funds Transfer Pricing Data Models
Last updated on JULY 15, 2010
Applies to:Oracle Financial Services Profitability Management - Version: 5.1
Oracle Financial Services Funds Transfer Pricing - Version: 5.1 and later [Release: 5 and later]
Oracle Financial Services Analytical Applications Infrastructure - Version: 7.1 and later [Release: 7 and later]
Information in this document applies to any platform.
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.
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