Oracle Forms

Hi, I am getting the above message when I try to generate a report . This is happening after I migrated from 6i to 10g. The main query in the report is as follows:

select F.facility_id,
F.domestic_registration_nbr,
F.field_establishment_nbr,
F.primary_business_name
from facilities F
where F.ber_status_text = 'ACTIVE'
and F.facility_id ; in (select B1.facility_id
from facilities F1,
ber_action_history B1
where F1.facility_id = B1.facility_id
and F1.ber_status_text = 'ACTIVE'
&P_WHERE2
and B1.action_type_cd = 'PA')
&P_WHERE1
&P_ORDER

If I take the parameters out and run the query in Toad the query works fine. any suggestions? Please help I have been stuck with this problem for days now.