Search list for a search parameter in Oracle BI EE works fine when the query doesn't contain a bind variable (parameter identifier). But when a bind variable is introduced in the constraint of search list query, it keeps on searching endlessly. For example,
-- this doesn't work
where table.col2 = :I_param_bind_var
-- this works
where table.col2 = 'xyz'
Using such bind variable in the list of values for menu parameters works fine. Is it an issue regarding publisher or am I missing something?