SQL Filter Issue - INSTR Function Causing Report Filters to Disappear for Specific Users

Rosita Santosuosso · Mar 27, 2026 9:25AM

Hi everyone,

we're experiencing an interesting issue with report filters in Oracle Learning Management (or similar).

Problem: When we use filters based on SQL queries, for some specific users the report filters disappear completely, making the report non-functional.

Technical Details: We've identified the critical point in the query that causes the error:

Copy

AND INSTR(',' || xxx.co_attribute1 || ',',           ',' || xle_le.legal_entity_identifier || ',') > 0

wlf_learning_items_f xxx

xle_entity_profiles xle_le

new 153.sql

Observed Symptoms:

Filters work correctly for most users
For specific users, filters disappear from the report
The query doesn't return errors, but simply doesn't apply the filters

Questions:

Has anyone else encountered similar behavior?
Could it be related to NULL values or whitespace in the co_attribute1 or legal_entity_identifier fields?
Do you have suggestions for better handling of this INSTR function in case of inconsistent data?

Any feedback will be greatly appreciated!

Thank you, Rosita

MandeepGupta · Mar 28, 2026 5:54PM

https://community.oracle.com/products/oracleanalytics/discussion/28552/sql-filter-issue-instr-function-causing-report-filters-to-disappear-for-specific-users

Hi Rosita,

Welcome to Oracle Analytics and AI community.

There is no such things as filter disappearing from BI reports. It is mostly that for some people the condition is failing.

Can you check the values of co_attribute1 and legalentity_identifier and then execute your iNSTR function standalone for those specific users for whom this report is not functioning as expected?

Thanks,

Mandeep.

Rosita Santosuosso · Mar 31, 2026 9:19AM

Hi,
I found the problem, and it seems to be solved with REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(TO_CHAR(SUBSTR(xxxtl.name, 0, 99)), '<[^>]*>', ' '), '&', '&'), '"', '”'), ' ', ' ')

or

SUBSTR(xxxtl.name, 1, 56) as name

on the filter "Titolo corso".

I also found a post with a similar problem:

Oracle BI Report > Parameter based on LOV having string limitations — Cloud Customer Connect

Can you tell me if there's a limit on the length of strings in filters?

Thanks

Regards

Rosita

MandeepGupta · Apr 4, 2026 2:57PM

Hi Rosita,

If your filters are at query level, then there is no restriction.

Thanks.

Oracle Business Intelligence Applications Forum

Categories

SQL Filter Issue - INSTR Function Causing Report Filters to Disappear for Specific Users

Answers