Hi Ganapati, Check the value, when multiple values were chosen. Its a collection and It was bundled with square parentheses []. Check the below SQLs. SQL1: SELECT '2018' P_YEAR FROM DUAL WHERE '2018' IN (:P_YEAR) UNION ALL SELECT '2019' FROM DUAL WHERE '2019' IN (:P_YEAR) UNION ALL SELECT '2020' FROM DUAL WHERE '2020' IN…