ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

Finders

Lists available finders and their attributes for querying views in Oracle Fusion applications.

SELECT

ViewName is required to get the mapping FinderName and finder parameter column.

The ViewName column supports = and IN operators

SELECT * FROM Finders where viewname = 'abc'
SELECT * FROM Finders where viewname IN ('abc','pqr')

Columns

Name Type Description
ViewName String Specifies the name of the database view for which a finder needs to be identified.
FinderName String The name of the finder, used to retrieve specific records from the view.
AttributeFinderColumn String The attribute within the finder that is used for filtering or searching records.
Type String Data type of the finder attribute, such as String, Integer, or Date.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175