Description
BI Publisher does not support KFF Lexical "Where" types with a LIKE operator correctly. The LIKE operator allows for wildcard searches (using %) to be conducted when searching for values. Unfortunately, static PL/SQL function workarounds lose indexing and cause timeouts. The standard Lexical functionality preserves indexing allowing for fast searches. There is no longer a concatenated segments field as there was in EBS.
Use Case and Business Need
This impacts users attempting to search for GL Accounts using partial account information (i.e. a segment). BI Publisher Lexical functionality allows for the 'concatenated segments' of an account to be retrieved and filtered by,
Example:
1406% to bring back all accounts starting with 1406.
Original Idea Number: e2a7296b6c
