My Oracle Support Banner

Troubleshooting Guide for FTP Transfer Rate Propagation Issues (Doc ID 2045657.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


This troubleshooting guide is a collection of knowledge documents created for Transfer Rate Propagation issues in Oracle Financial Services Funds Transfer Pricing (FTP).  Note: The version in parentheses () is the version in which the issue is originally reported.  The issue may apply to later versions also.

The following setup requirements exist in Chapter 27 "Propagation Pattern" of the FTP User Guide:

When a table is updated using a propagation pattern, an instrument record must satisfy the following criteria to receive a transfer rate, adjustment rate or option cost:

1. It must be an instrument that exists in both the Target (processing) table (with the current As of Date) and the Source table (with the prior period based on a matching ID_NUMBER.).

2. The instrument must also satisfy one of the following conditions:

Fixed Rate: It must be a fixed-rate (Repricing Freq = 0 in Target table) instrument.

Adjustable Rate: It must be an adjustable-rate (Repricing Freq <> 0 in Target table) instrument with Target Last Repricing Date <= Prior Period As of Date.  In other words, it must be an adjustable-rate instrument that has not repriced since the prior period.

The matched spread is also migrated from the prior period record and not recomputed from the Transfer Rate and Current Rate on the target table record.

For Adjustment Rate Propagation, all rates are propagated regardless of fixed or adjustable type.  If additional logic is required to control Propagation of Adjustment Rates, data filters should be used to specify the conditions.

Troubleshooting Steps

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
Troubleshooting Steps
 1. Propagation Pattern fails to generate Transfer Rates (
 2. Tables missing from FTP Propagation Patterns screen (5.6)
 3. Columns Missing from Transfer Rate Propagation Selector (
 4. Propagation ignores the "Skip Non-zero Transfer Rate Record" option (5.2)
 5. Adjustment Propagation does not consider the Repricing Frequency (5.6)
 6. Charge/credits not calculated with rate propagation (
 7. ORA-01747: invalid user.table.column, table.column, or column specification running Rate Propagation (6.1)

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