R12 Projects Endeca: Expediture Overview: How to filter out only Employee Expenses without hard coding Supplier Name (Doc ID 2240776.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Project Planning and Control - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

Projects Endeca: Expenditure Overview Page - How to display a list of Employee Expenses:

Employee Expenses consists of:

1. Expense reports interfaced to Projects from iExpenses
2. Supplier Invoices for travel expenses raised on Suppliers like Amex, Visa etc. These do not have Employee Name.

All the expenditures are available in Expenditure Overview but we cannot find a way to filter out only Employee Expenses without hard coding Supplier Name as 'Amex' OR 'Visa' in the EQL View.

If we had to do this in EBS, we could create a lookup which is easily maintained. But in Endeca, it is difficult without hard coding names.
Is there an alternative to filter?


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms