SQL Query using the IN Syntax & Passing Parameter

The BI Publisher Data model does not compile using the IN syntax and parameters . When a value is hard-coded in the IN parameter the result set is generated.
Creating a data model with a simple select statement from the Company Constants table using the in syntax and parameter returns the error

SQL Query :
select "F0010"."CCC0" as "CCCO" , "F0010"."CCNAME" as "CCNAME" from "PRODDTA"."F0010" "F0010"
where "F0010"."CCCO" in (:Param1)

Error: [SQL0206] Column or Global variable NULL not found

The same query with the hard coded value returns the data

SQL Query :
select "F0010"."CCC0" as "CCCO" , "F0010"."CCNAME" as "CCNAME" from "PRODDTA"."F0010" "F0010"