Which filter can be used to identify expense reports that contain suspicious expense type combinations, such as, a report for a single trip that…

The Inclusive Function filter keeps only those groups that contain ALL of the specified values. To find reports that simultaneously include Taxi, Car Rental, and Mileage lines, group the data by Expense-Report “Report Number” (one group per report) and apply an Inclusive filter on the “Expense Type” attribute with an “IN (Taxi, Car, Mileage)” condition. Any report returned by the filter necessarily contains the suspicious combination.

A – Using “Equals” would look for a single row where Expense Type equals all three values—impossible.

B – Duplicate of D; one option retained.

C – Grouping by Person mixes multiple reports; may flag employees who happened to submit the three types on different reports.

E – Same grouping problem as C.

1. Oracle Risk Management Cloud User Guide 24A, “Use of Inclusive and Exclusive Function Filters”, example 2 (Expense types), paragraphs 1-3.

2. Oracle Risk Management Cloud Tutorial: “Detect Expense-Type Combinations with Inclusive Function” (Oracle Learning Library Video RM-2204).