1. User Guide
  2. Business Rules Administration
  3. Application Specific Rules
  4. Transfer Pricing Rules
  5. Overview of Transfer Pricing Methodologies and Rules

5.3.4.1 Overview of Transfer Pricing Methodologies and Rules

The Transfer Pricing Methodologies supported by Oracle Funds Transfer Pricing Cloud Service can be grouped into the following categories:

Cash Flow Transfer Pricing Methods: Cash Flow Transfer Pricing Methods are used to Transfer Price Instruments that amortize over time. They generate transfer rates based on the Cash Flow characteristics of the instruments.

To generate Cash Flows, the system requires a detailed set of transaction-level data attributes, such as, Origination Date, Outstanding Balance, Contracted Rate, and Maturity Date, which resides only in the Instrument Tables. Consequently, Cash Flow Methods apply only if the Data Source is Account Tables. Data stored in the Management Ledger Table reflects only accounting entry positions at a particular point in time and does not have the required financial details to generate Cash Flows, therefore, preventing you from applying Cash Flow Methodologies to this data.

The Cash Flow Methods are also unique in that Prepayment Rules are used only with these methods. You can select the required Prepayment Rule when defining a Transfer Pricing Process.

Oracle Funds Transfer Pricing Cloud Service supports the following Cash Flow Transfer Pricing Methods:

  • Cash Flow: Average Life
  • Cash Flow: Duration
  • Cash Flow: Weighted Term
  • Cash Flow: Zero Discount Factors

Non-Cash Flow Transfer Pricing Methods: These methods do not require the calculation of Cash Flows. While some of the non-Cash Flow Methods are available only with the Account Tables Data Source, some are available with both the Account and Ledger Table Data Sources.

Oracle Funds Transfer Pricing Cloud Service supports the following Non-Cash Flow Transfer Pricing Methods:

  • Moving Averages
  • Straight Term
  • Spread from Interest Rate Code
  • Spread from Note Rate
  • Redemption Curve
  • Tractor Method
  • Caterpillar
  • Weighted Average Perpetual
  • Unpriced Account

Oracle Funds Transfer Pricing Cloud Service also allows Mid-period Repricing. This option allows you to take into account the impact of high market rate volatility while generating transfer prices for your products. However, the mid-period Repricing option applies only to Adjustable-Rate Instruments and is available only for certain Non-Cash Flow Transfer Pricing Methods.

Note on Bulk Updates versus Row by Row Processing: Any Transfer Pricing Method that does not refer to individual account characteristics utilizes a bulk update to assign a single transfer rate to a group of instrument records. Any TP Method that needs to refer to individual account characteristics to process will execute on a row-by-row basis. In general, Bulk updates are faster than row-by-row processing.

The following Transfer Pricing Methods, when not defined through a conditional assumption and not utilizing Mid-Period Repricing, use Bulk Updates:

  • Redemption Curve (Assignment Date = As-of-Date only)
  • Moving Average
  • Spread from Note Rate
  • Spread from IRC (Assignment Date = As-of-Date only)

All other Transfer Pricing Methods like Tractor, Caterpillar, and Weighted Average Perpetual are processed row-by-row. When Conditional Assumptions or Mid Period Repricing are used, processing will always be row-by-row, regardless of the Transfer Pricing Method Selection.