In Oracle Fusion Cloud HCM Cloud, finders are filters used for searching collection resources. Each finder has several parameters bound to it.

Using Finders with Parent View

To use a finder filter with a parent view, you need to provide the FinderName in the finder pseudo column and provide values for the finder parameter columns.

SELECT * FROM Absences WHERE finder = 'PrimaryKey' AND PersonAbsenceEntryId = 300000074177554;

Using Finders with Child View

To use a finder filter with a child view, you need to provide the FinderName of the parent view in the finder pseudo column and provide values for the finder parameter columns of the parent view.

SELECT * FROM AbsencesabsenceRecordingsDDF WHERE finder = 'PrimaryKey' AND PersonAbsenceEntryId = 300000074177554;