My Oracle Support Banner

FTP Transfer Charge Credit Amounts Are Not Populated For 'Spread from Note Rate' Transfer Pricing Methods (Doc ID 1414165.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 5.6 to 5.6 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x

Checked for relevance on 04-Oct-2013.


On Oracle Financial Services Funds Transfer Pricing (FTP) 5.6, when attempting to generate TP Charge Credit results at the instrument level, no tp charge credit results are written.

Even though both Transfer Rate and Instrument Charge/Credit (TP) are checked in the FTP Standard Process, and transfer_rate is correctly written, nothing is written to the charge_credit_trate field.

In addition, the update statement generated in the FTP Debug log does not include CHARGE_CREDIT_TRATE:

Module Logging OFS calculation module data: update
update FSI_D_CASA a
set transfer_rate = cur_net_rate+ :transfer_rate,
matched_spread_c = :matched_spread_c
and as_of_date = to_date('12/ 31/ 1999', 'mm/ dd/ yyyy')

Confirmed however that the charge_credit_flag = 'Y' in fsi_m_tp_process_rule:

select charge_credit_flag from fsi_m_tp_process_rule where tp_process_sys_id = 201709;

CHARGE_CREDIT_TRATE to be populated if it is selected in the FTP Standard Process.

The issue can be reproduced at will with the following steps:
1. Update Application Preferences:

As of Date : 12/31/1999
Transfer Pricing Options:
TP Charge/Credit Balance: Ending Book Balance

2. Create new TP rule with Spread from Note Rate: coki_prod_chargecredit
==> Tried at both node level, then leaf level only

3. Create new FTP Standard Process: coki_ftp_charge_credit
==> Tried w/o migration defined, only choose the following:

Calculation Selection:
Checked: Transfer Rate and Instrument Charge/Credit (TP)

Ran the process => Confirmed new TRANSFER_RATE is generated but no charge_credit_trate or transfer_charge_credit.


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.