How to Add User Defined Adjustment Columns to Instrument Tables for FTP (Doc ID 1299205.1)

Last updated on MAY 13, 2015

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 5.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Checked for relevance on 05-Jul-2013.

Goal

In Oracle Funds Transfer Pricing (FTP) 5.2, there are five seeded Adjustment Types in an Adjustment Rule:

Basis Risk Costs
Breakage Charges
Liquidity Adjustment
Other Adjustments
Pricing Incentive

Each Adjustment Type has related columns on the instrument tables (ex. LIQUIDITY_PREMIUM_AMT, LIQUIDITY_PREMIUM_RATE, LIQUIDITY_PREM_CHARGE_CREDIT, BASIS_RISK_COST_AMT, BASIS_RISK_COST_RATE, BASIS_RISK_CHARGE_CREDIT, etc.) that are populated by the FTP Process.

Is there a way to add user defined / custom columns to the instrument tables and populate them with additional Adjustment amounts and rates?

Solution

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