My Oracle Support Banner

ORA-00907: missing right parenthesis Driver Function Error Running FTP Process Using a Data Filter on a Custom Column (Doc ID 2652603.1)

Last updated on APRIL 01, 2020

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On FTP 6.1.1 after adding one column to the FSI_D_CASA table, when this is being used in the FTP process then during execution it is not putting expected quotations in the query. The following error is then thrown in the FTP debug log:

ERROR

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
  oexn() SQL Function: [0] - SQL function not found! Oracle Error:
  ORA- 00907: missing right parenthesis Driver Function:
  drv_oci::Execute() SQL Statement:
select distinct a.ISO_CURRENCY_CD, a.PRODUCT_ID
from <ATOMIC>.FSI_D_CASA partition(SYS_P140) a
where (((a.ACCOUNT_GROUP_CD = '30113'))
and ((a.DATA_SOURCE_CD = '1003'))
and ((a.ISO_CURRENCY_CD = 'INR'))
and ((a.CUR_BOOK_BAL>250000000.00
and a.CUR_BOOK_BAL<=999999999999999.00))
and ((a.PRODUCT_TYPE_CD < '30436'
or a.PRODUCT_TYPE_CD > '30436'))
and ((a.<NEW_COLUMN> = OTHER LEGAL ENTITIES)))
and as_of_date = to_date('02/ 14/ 2020', 'mm/ dd/ yyyy')
order by a.ISO_CURRENCY_CD, a.PRODUCT_ID


As can be seen above, the line for the new column is missing ' ' around the filter value:

and ((a.<NEW_COLUMN> = OTHER LEGAL ENTITIES)))


Expected line:

and ((a.<NEW_COLUMN> = 'OTHER LEGAL ENTITIES')))

This is working without issue for the another similar column on the same table.

The issue can be reproduced at will by the customer with the following steps:
1. Add a new column to the FSI_D_CASA table
2. Updated existing Data Filter -> Sys ID 204579 and added additional filter line for the new column:

AND Checking and Savings Account-:include Specific Values:= OTHER LEGAL ENTITIES

3. Run existing FTP Process - 204582 for As Of Date: 20200214 on FSI_D_CASA table using same updated Data Filter.

Changes

New user defined custom column is added to a table for use in a data filter.

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
Changes
Cause
Solution
References


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