Search Results okl_fe_criterion_values

Overview

The table OKL_FE_CRITERION_VALUES is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as a child table that stores the specific values or parameters defined for individual eligibility criteria lines. In the context of the OKL module's financial eligibility engine, this table plays a critical role in configuring and evaluating the detailed rules that determine whether a customer, asset, or transaction qualifies for a specific financial product or offer. Each record in this table represents a concrete value tied to a criterion, enabling precise and configurable rule definitions.

Key Information Stored

The table's primary purpose is to hold the detailed values for criteria lines. While the full column list is not provided in the metadata, the documented foreign key relationship and primary key reveal its essential structure. The primary key column, CRITERION_VALUE_ID, uniquely identifies each criterion value record. The foreign key column, CRITERIA_ID, links each value back to its parent criterion definition in the OKL_FE_CRITERIA table. Other typical columns in such a structure would include fields to store the actual value (e.g., a number, date, or text string), an operator for comparison (like '=', '>', 'BETWEEN'), and potentially a sequence number to order multiple values for a single criterion. These columns collectively define the operands for the eligibility rules.

Common Use Cases and Queries

This table is central to the setup and execution of financial eligibility checks. A common use case involves reporting or debugging the complete set of rules for a specific eligibility model. For instance, an analyst might need to list all criterion values for a particular criteria header. A typical query would join OKL_FE_CRITERION_VALUES to its parent table, OKL_FE_CRITERIA, and further to the criteria header table. Sample SQL to retrieve this information would follow this pattern:

• SELECT cv.criterion_value_id, cv.criteria_id, c.criteria_name, cv.operator, cv.value
• FROM okl_fe_criterion_values cv, okl_fe_criteria c
• WHERE cv.criteria_id = c.criteria_id
• AND c.criteria_header_id = :p_header_id;

Data in this table is primarily maintained through the Oracle EBS application's eligibility configuration screens, not via direct SQL manipulation.

Related Objects

OKL_FE_CRITERION_VALUES has a direct and documented hierarchical relationship within the eligibility engine's data model. As per the provided metadata, it is a child table with a single, critical foreign key dependency:

• OKL_FE_CRITERIA: This is the immediate parent table. The relationship is defined by OKL_FE_CRITERION_VALUES.CRITERIA_ID referencing OKL_FE_CRITERIA. The OKL_FE_CRITERIA table holds the definition of the criterion itself (e.g., "Maximum Debt-to-Income Ratio"), while OKL_FE_CRITERION_VALUES stores the specific threshold value (e.g., "0.45").

Consequently, OKL_FE_CRITERION_VALUES is a leaf-level table in this hierarchy, feeding into the broader eligibility evaluation processes managed by the OKL module's application logic and APIs.