My Oracle Support Banner

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

Last updated on JULY 16, 2018

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

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.