ORA-01747 Error Occurs When Running Allocation Id On a Instrument Table (Doc ID 749865.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Applications (OFSA) - Version: 4.5
Oracle Performance Analyzer - Version: 4.5
Oracle Profitability Manager - Version: 4.5.20 to 4.5.39
This problem can occur on any platform.

Symptoms

When attempting to run Allocation ID on an instrument table (e.g.: TERM_DEPOSITS), the following error occurs:

ERROR
-----------------------
(2013105) Oracle drv_oci error:

Oracle Error: ORA-01747: invalid user.table.column,table.column, or column specification

When running the Data Filter ID used in the Allocation, the generated Sql does not properly reference one column:

In the where clause instead of  TERM_DEPOSITS.ORG_TERM_MULT = 'M' there is TERM_DEPOSITS. = 'M'

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