My Oracle Support Banner

Nothing Happens When Trying to Save Transfer Pricing Rule Definition in FTP (Doc ID 2473422.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


In Oracle Financial Services Funds Transfer Pricing (FTP), when attempting to create a new Transfer Pricing Rule definition for a Product, after filling in the required information and clicking on 'Apply', nothing happens.  The definition window remains and there are no messages.  If you close the window manually and close and re-open the Transfer Pricing Rule, you find the definition is not saved.

The messages like the following exist in the ftpapp.log in the web server's OFSAA log directory:

[15-11-18 18:36:05,561 GMT PM] [INFO ] [WEB] Sql Statement::: insert into FSI_M_TRANSFER_PRICE_RULE(transfer_price_sys_id,product_id,ccy_cd,cond_sys_id,product_hierarchy_id,data_source_cd,tp_calc_method_cd,gross_rate_flg,target_bal_cd,interest_rate_cd,output_dur_to_inst_flg,cash_flow_discount_method_cd,single_rate_discounting_cd,constant_rate,weighted_term_cash_flow_cd,mid_period_reprice_flg,yield_curve_term,yield_curve_mult,historical_term,historical_mult,rate_spread,assignment_date_cd,lag_term,lag_mult,caterpillar_method_cd,across_org_unit_flg,output_avg_life_to_inst_flg,pattern_code,option_cost_method_cd,cash_flow_type_cd,cond_sequence,ev_cf_interest_type,ev_interest_only_flg,ev_excl_acrud_int_flg,ev_irc_cd,ev_rate_spread,ev_tpr_calc_flg,holiday_calendar_code,holiday_rolling_convention_cd,holiday_calc_option_cd,tp_rate_term,tp_term_operator,tp_term_adj_amount,OUTPUT_AUDIT_FLG) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ,?,?,?,?,?,? ,?,?,?,?,?,?,?)
[15-11-18 18:36:05,561 GMT PM] [INFO ] [WEB] transfer_price_sys_id 200425
product_id 30201
ccy_cd USD
Cond_sequence -1
product_hierarchy_id 200065
tp_calc_method_cd 4
[15-11-18 18:36:05,561 GMT PM] [INFO ] [WEB] BEFORE EXECUTING::::::::::::::::::::::
[15-11-18 18:36:05,561 GMT PM] [ERROR] [WEB] Error~ Missing IN or OUT parameter at index:: 4

As a result of this issue, you cannot setup required Transfer Pricing Rule definitions.


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.