Search Results okl_fe_crit_cat_def_b




Overview
Explore in AI Chat

Overview

The OKL_FE_CRIT_CAT_DEF_B table is a core data definition table within the Oracle E-Business Suite Lease and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. As the base table for Criteria Categories, it serves as the master repository for defining the logical groupings or classifications of business rules and conditions used in the leasing and financing processes. These categories are fundamental to the configuration and execution of complex financial evaluations, enabling the system to organize and apply criteria consistently across contracts and transactions. Its role is central to the flexible criteria engine, allowing for the structured definition of rule sets that drive calculations, validations, and decision-making workflows.

Key Information Stored

While the provided metadata does not list specific column names beyond key identifiers, the structure and relationships indicate the table stores definitional metadata for criteria categories. The primary column is CRIT_CAT_DEF_ID, which uniquely identifies each category definition. The table also includes an ORIG_CRIT_CAT_DEF_ID column, which creates a self-referential foreign key relationship, suggesting support for versioning or inheritance where a new category definition can be based on an original. The FUNCTION_ID column links the category to a specific data source function defined in the OKL_DATA_SRC_FNCTNS_B table, indicating that the logic or data for evaluating criteria within this category is tied to a backend PL/SQL function. Other typical columns in such a base table would include creation date, created by, last update date, last updated by, and object version number for data integrity and auditing.

Common Use Cases and Queries

This table is primarily accessed during the setup and configuration of leasing rules, and during runtime when the system evaluates contracts against defined criteria. Common operational and reporting scenarios include auditing the hierarchy of category definitions and identifying all criteria associated with a specific functional area. A typical query would join to related tables to analyze the criteria framework. For example, to list all criteria categories and their associated source functions, one might use: SELECT cat_def.CRIT_CAT_DEF_ID, fnctn.FUNCTION_NAME FROM OKL_FE_CRIT_CAT_DEF_B cat_def, OKL_DATA_SRC_FNCTNS_B fnctn WHERE cat_def.FUNCTION_ID = fnctn.FUNCTION_ID; Another common pattern is tracing the lineage of a category definition: SELECT child.CRIT_CAT_DEF_ID, parent.CRIT_CAT_DEF_ID AS ORIGINAL_ID FROM OKL_FE_CRIT_CAT_DEF_B child LEFT JOIN OKL_FE_CRIT_CAT_DEF_B parent ON child.ORIG_CRIT_CAT_DEF_ID = parent.CRIT_CAT_DEF_ID;

Related Objects

The OKL_FE_CRIT_CAT_DEF_B table is a central node in the criteria definition schema, with several key relationships documented in the ETRM. The table is referenced by, and references, the following objects:

  • Self-Reference (Hierarchy/Versioning): OKL_FE_CRIT_CAT_DEF_B.ORIG_CRIT_CAT_DEF_ID → OKL_FE_CRIT_CAT_DEF_B(CRIT_CAT_DEF_ID). This allows for derived or versioned category definitions.
  • Data Source Function: OKL_FE_CRIT_CAT_DEF_B.FUNCTION_ID → OKL_DATA_SRC_FNCTNS_B. This links the category to the PL/SQL logic that supplies data for criteria evaluation.
  • Criteria Definitions: OKL_FE_CRITERIA.CRIT_CAT_DEF_ID → OKL_FE_CRIT_CAT_DEF_B. Individual criteria (OKL_FE_CRITERIA) are grouped under a category defined in this table.
  • Category Objects: OKL_FE_CRIT_CAT_OBJECTS.CRIT_CAT_DEF_ID → OKL_FE_CRIT_CAT_DEF_B. This table likely maps the category to specific database objects or entities relevant to the criteria.