BI Publisher: Setting parameter as "multiple selection" returns XML ouput error

Dear guys,

I am currenting working on an issue of bi publisher (11.1.1.6.12), it is such a common function which should not even have this kind of error, at least as I think...The issue is described as follows:

BI publisher usage:

Integrating with Oracle EBS(12.1.3), creating data model using pure SQL queries.

Database version:

11g 11.1.0.7

Problem reproduction:

1. Define a list for returning project name.

2. Set one parameter (e.g. P_PROJECT) using the values of the predefined project list. Set the selection option as "multiple selection".

3. Add one filter sentence "...and t1.project_name in (:P_PROJECT)" in the data model SQL.