TP Process Using Alternate Rate Output Fails with Error 'ORA-01036: Illegal Variable Name/ Number'
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)
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:  - obndra() SQL
Function:  - 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
where process_node is not null
and node_map_id = 279)
The error prevents the Transfer Rates from getting calculated.
Steps to Reproduce:
- Go to Funds Transfer Pricing
- Go to Assumption Specification > Alternate Rate Output Mapping
- Create a new Alternate Rate Output Rule and only define an alternate column for "Transfer Rate". Leave the remaining fields blank.
- Go to FTP Processing > Standard Process
- Create an FTP Process that has Transfer Rate and Alternate Rate Output selected
- Run the FTP Process
The process ends in a status of Failed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms