TP Process Using Alternate Rate Output Fails with Error 'ORA-01036: Illegal Variable Name/ Number'

(Doc ID 1582344.1)

Last updated on SEPTEMBER 09, 2013

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.0 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 "Alternate Rate Output" selected, the process fails.  You want to output the Transfer Rate to a different column so you created an Alternate Rate Output Mapping definition and selected the alternate column.  The definition only maps the "Transfer Rate" column to an alternate column.  The other columns are not defined / blank.  See example below:

You run the FTP process with this definition and it fails.

The following error exists in the ofstp.xxxxxx.err file in $FIC_DB_HOME/log/FusionApps:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [62] - obndra() SQL
    Function: [0] - SQL function not found! Oracle Error: ORA- 01036:
    illegal variable name/ number Driver Function:
    drv_oci::BindColOut() SQL Statement:
update    FSI_D_MORTGAGES a
set    LIQUIDITY_PREMIUM_RATE = :LIQUIDITY_PREMIUM_RATE, =
    cur_net_rate - :
where    a.ISO_CURRENCY_CD = :ISO_CURRENCY_CD
and    a.PRODUCT_ID = :PRODUCT_ID
and    as_of_date = to_date('07/ 31/ 2013', 'mm/ dd/ yyyy')
and    PRODUCT_ID in (select prod_id
from    fsi_process_node_map
where    process_node is not null
and    node_map_id = 279)

The error prevents the Transfer Rates from getting calculated.

Steps to Reproduce:

  1. Go to Funds Transfer Pricing
  2. Go to Assumption Specification > Alternate Rate Output Mapping
  3. Create a new Alternate Rate Output Rule and only define an alternate column for "Transfer Rate".  Leave the remaining fields blank.
  4. Go to FTP Processing > Standard Process
  5. Create an FTP Process that has Transfer Rate and Alternate Rate Output selected
  6. Run the FTP Process

The process ends in a status of Failed.

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