No Transfer Rate Output for Products with Caterpillar Transfer Pricing Method
Last updated on JUNE 14, 2018
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)
In Oracle Financial Services Funds Transfer Pricing (FTP), when you run an FTP process with a Transfer Pricing Rule that uses the Caterpillar method, you are not getting a Transfer Rate output for all products. Some products may get assigned a rate but others do not.
You may have the following error in the ofstp.xxxxx.log in $FIC_DB_HOME/log/FusionApps:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function:  - oexec(),
oexn() SQL Function:  -
INSERT Oracle Error: ORA- 00001: unique constraint
(<atomic>.XAK1FSI_TP_CATERPILLAR_INTRMDI) violated Driver Function:
drv_oci::Execute() SQL Statement:
insert into FSI_TP_CATERPILLAR_INTRMDIATE(tp_process_sys_id,
pattern_code, org_unit_id, gl_account_id, cf_amt, rate,
product_id, tenor, multiplier, ccy_cd, period, mis_date)
values (:tp_process_sys_id, :pattern_code, :org_unit_id,
:gl_account_id, :cf_amt, :rate, :product_id, :tenor, :multiplier,
:ccy_cd, :period, :mis_date )
Even after deleting rows from FSI_TP_CATERPILLAR_INTRMDIATE, you still may not get all Transfer Rates output.
Steps to Reproduce:
- Go to Funds Transfer Pricing
- Go to FTP Processing > Standard Process
- Run the FTP Process with a Transfer Rule using the Caterpillar method
Not all product get assigned transfer rates in the instrument table.
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