To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Creating a BI Publisher report having parameters with LOV selection (selecting more than one value)
Summary
Creating a BI Publisher report having parameters with LOV selection (selecting more than one value) is causing error.Content
Creating a BI Publisher report having parameters with LOV selection (selecting more than one value) is causing error. Selecting one value is fine. Any thoughts???
Error
The report cannot be rendered because of an error, please contact the administrator.
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00909: invalid number of arguments
Error Screen Shot is attached