Allocation with Filter Fails with 'ORA-00907: Missing Right Parenthesis' Due to Missing Quotes Around Values (Doc ID 1980610.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 6.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT), an Allocation using a range filter on a character data element column fails.  The following ORA-00907 error exists in the View Log information:

Oracle Error: ORA-00907: missing right parenthesis

SQL Statement: INSERT INTO FSI_M_DATA_IDENTITY_DETAIL
(identity_code, as_of_date, src_drv_as_of_date, src_drv_type,
row_count, balance, parent_identity_code, balance_type_cd)
SELECT 17155.000000000000000, '11/30/2014', '11/30/2014', 'S',
TT.*,105.0000000000000 from (select count(a.identity_code),
SUM(NVL(FEE_AMT,0)), NVL(a.identity_code_chg,0)
from FSI_D_MORTGAGES a where
(((a.COMMON_COA_NAME>=1111200000 and
a. COMMON_COA_NAME<=111120ZZZZ))) and
a.as_of_date='11/30/2014' group by NVL( a.identity_code_chg,
0) ) TT


The error occurs because there are no single quotes around the COMMON_COA_NAME values selected in the filter.  You expect the code to place single quotes around character values automatically.

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