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

Last updated on DECEMBER 28, 2016

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)

Symptoms

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.

Cause

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