My Oracle Support Banner

No Transfer Rate Output for Products with Caterpillar Transfer Pricing Method (Doc ID 1481043.1)

Last updated on MARCH 05, 2019

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: [4] - oexec(),
    oexn() SQL Function: [3] -
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:

  1. Go to Funds Transfer Pricing
  2. Go to FTP Processing > Standard Process
  3. Run the FTP Process with a Transfer Rule using the Caterpillar method

Not all product get assigned transfer rates in the instrument table.




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.