Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 194 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 67 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Searching for data using flex fields in datamodels

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
Comments
-
Moved from Purchasing forum.
0