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:

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