FA OTBI: Expenses – Expense Transactions Real Time - Employee Name Search Not Working (Doc ID 2463343.1)

Last updated on JUNE 28, 2022

Applies to:

Goal

Expenses – Expense Transactions Real Time Subject Area.

Create simple analysis which includes fields Employee Name and Report Number. However search for the Employee Name, results in search do not appear.

Example: click filter -> search -> Contains "<First Name>" (without quotes, uncheck match case) and no results appear in the search.

Using Employee Name field as a prompt so users can search by employee name and return the report number. If I enter the person's name directly I get results, but if I search for that person I do not get a match and hence cannot enter a parameter. Some employees are appearing while others are not

This is for employee: FirstName, LastName

Issue: Employee Name filter using "Expenses - Expense Transactions Real Time"

==========================================================
1. Employee Name with comma is not showing in the filter list. Example: 'FirstName, LastName'
2. Even these customer are not showing in the report output.
3. When we add the any column from other folder, can see comma delimited employees in the report output, and the filter works if we hard code the employee name.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.