Search Results okl_fe_criteria

Overview

The OKL_FE_CRITERIA table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Lease and Finance Management (OKL) module. It functions as the detailed repository for eligibility criteria line attributes. In the context of financial services and leasing, eligibility criteria define the specific conditions, rules, or thresholds that must be evaluated for a transaction, such as a lease application or funding request. This table stores the individual criteria lines that collectively form a complete rule set, enabling systematic and automated qualification assessments within the Oracle EBS workflow.

Key Information Stored

The table's primary purpose is to define each discrete criterion within a larger set. Its structure is centered around identifiers and references that establish relationships and context. The primary key, CRITERIA_ID, uniquely identifies each criterion record. The CRITERIA_SET_ID is a critical foreign key that links the criterion to its parent rule set defined in the OKL_FE_CRITERIA_SET table. Another essential foreign key, CRIT_CAT_DEF_ID, references the OKL_FE_CRIT_CAT_DEF_B table, which defines the category or type of the criterion (e.g., financial ratios, credit scores, asset attributes). While the provided metadata does not list all columns, the table's description implies it holds attributes specific to the criterion line, which would typically include configuration for the evaluation logic, sequence, and operational flags.

Common Use Cases and Queries

This table is central to the configuration and execution of eligibility checks. A primary use case is the setup and maintenance of complex qualification rules for products or funding sources. For reporting and analysis, common queries involve listing all criteria within a specific set or analyzing the types of criteria used across different rule sets. Sample SQL patterns include retrieving criteria details for a known criteria set or joining with related tables to get a full view of a rule definition.

• Retrieve all criteria lines for a specific eligibility rule set: SELECT * FROM OKL.OKL_FE_CRITERIA WHERE CRITERIA_SET_ID = <set_id> ORDER BY <sequence_column>;
• Join with the category definition to understand criterion types: SELECT c.*, cat.MEANING FROM OKL.OKL_FE_CRITERIA c, OKL.OKL_FE_CRIT_CAT_DEF_B_TL cat WHERE c.CRIT_CAT_DEF_ID = cat.CRIT_CAT_DEF_ID AND cat.LANGUAGE = USERENV('LANG');

Related Objects

The OKL_FE_CRITERIA table exists within a well-defined schema hierarchy, as evidenced by its documented foreign key relationships.

• Parent/Dependent References: The table is a child of OKL_FE_CRITERIA_SET via the CRITERIA_SET_ID column. It is also a child of OKL_FE_CRIT_CAT_DEF_B via the CRIT_CAT_DEF_ID column, which provides the categorical definition for the criterion.
• Child/Referencing Objects: The table is a parent to the OKL_FE_CRITERION_VALUES table. The CRITERIA_ID primary key is referenced by the CRITERIA_ID foreign key in OKL_FE_CRITERION_VALUES, which is where specific allowable values or thresholds for each criterion are stored.

This relationship chain (OKL_FE_CRITERIA_SET → OKL_FE_CRITERIA → OKL_FE_CRITERION_VALUES) forms the structural backbone for defining and storing configurable eligibility rules within Oracle Lease and Finance Management.