ORA-00907: missing right parenthesis https://docs.oracle.com/error-help/db/ora-00907/

Question

Hi Folks,

One of our client requirement is to develop an "An audit report for Requisition", we develop the report but facing issue while adding parameters in the query , the objective is to allow "Multiple Requisition Number  and Last Update Date" parameter in the report, but we get this following error while adding the parameter.

"ORA-00907: missing right parenthesis https://docs.oracle.com/error-help/db/ora-00907/"

"and IRB.REQUISITION_NUMBER in (:p_REQUISITION_NUMBER) IS NULL OR IRB.REQUISITION_NUMBER =:p_REQUISITION_NUMBER"

The query contains multiple UNIONS.

Please assist.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/67213#Comment_67213

You have to do it for all the prompts that you are using if you are using similar query for others too.

If possible attach your catalog here so that we will try to replicate in our instance and which will be helpful to get a potential resolution.

Thank you.

Sushant95-Oracle · Answer

Still getting the same error.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/25571/ora-00907-missing-right-parenthesis-https-docs-oracle-com-error-help-db-ora-00907

Hi @Sushant95-Oracle,

Please try the following way to see if there's any betterment.

and (
IRB.REQUISITION_NUMBER in (:p_REQUISITION_NUMBER) IS NULL 
OR IRB.REQUISITION_NUMBER =:p_REQUISITION_NUMBER
)

Hope this help.

Thank you.