You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabled

in Reporting and Analytics for ERP 2 comments

Summary:

Hi Team,

I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the where clause where the parameter of 'Menu' type i.e. P_TCA_TABLE_NAME is used for comparing with a text value :


But when I pass multiple values to the parameter got 'ORA-00920: invalid relational operator' error. However same query works fine when single value is passed for that parameter.

Below please find more screenshots.

Please help.

Thanks

Content (please ensure you mask any confidential information):

Error screenshot :

Parameter is of 'Menu' type with 'Multiple Selection' enabled.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!