My Oracle Support Banner

TP Process Using Alternate Rate Output Fails with Error 'ORA-01036: Illegal Variable Name/ Number' (Doc ID 1582344.1)

Last updated on MARCH 05, 2019

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)


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
    cur_net_rate - :
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.


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.