My Oracle Support Banner

Ranges in Data Filter ORA-00907 Missing Right Parenthesis (Doc ID 2538335.1)

Last updated on AUGUST 12, 2019

Applies to:

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


On : 8.0.6 version, Filters

When using a Data Filter with Ranges filter method on Amortization Term and Amortization Multiplier, the following error occurred.

ORA-00907: missing right parenthesis

Steps to Replicate:
1. Create a Data Filter on Mortgages and Filter on Ranges for Amortization Term and Amortization Multiplier.
    Use Ranges >=1  & <=24 Months

2. Save and run SQL View and found below statement:

3. Run the above query and received ORA-00907.

4. Use the above statement in an Allocation Rule and found error below:
    ORA- 00933: SQL command not properly ended Driver Function
    ORA- 00907: missing right parenthesis Driver Function




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

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