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