Searching for data using flex fields in datamodels

David Wright - More4apps

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

Suman Guha-Oracle

Moved from Purchasing forum.