Search Results okl_fe_crit_cat_objects




Overview
Explore in AI Chat

Overview

The table OKL_FE_CRIT_CAT_OBJECTS is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Lease and Finance Management (OKL) module. It serves a critical function in the configuration of eligibility criteria, a foundational concept for structuring and automating financial product offerings. Specifically, this table defines the applicable object classes that can be associated with a given eligibility criteria category. In practical terms, it acts as a cross-reference or mapping table that governs which types of business entities (e.g., parties, assets, contracts) a specific set of eligibility rules can be evaluated against. This ensures that criteria are only applied to logically relevant objects within the leasing and finance lifecycle.

Key Information Stored

The table's primary purpose is to maintain the relationship between a criteria category definition and the object classes it governs. The documented structure highlights two key columns. The CRIT_CAT_DEF_ID column is a foreign key that links to the base definition table for eligibility criteria categories (OKL_FE_CRIT_CAT_DEF_B). The OBJECT_CLASS_ID column holds the identifier for a specific object class (such as 'OKL_PARTY' for a customer or 'OKL_ASSET' for a leased item) that is valid for the linked criteria category. This column is also the table's primary key, enforcing uniqueness for each object class association within a criteria category definition. The combination of these fields configures the permissible scope of an eligibility rule set.

Common Use Cases and Queries

This table is primarily accessed during the setup and validation of eligibility criteria. A common administrative task is to review all object classes permitted for a specific criteria category. The following query pattern illustrates this, joining to the criteria category definitions table to get a meaningful name:

  • Sample Query: SELECT cat_def.NAME, obj.OBJECT_CLASS_ID FROM OKL_FE_CRIT_CAT_OBJECTS obj, OKL_FE_CRIT_CAT_DEF_B cat_def WHERE obj.CRIT_CAT_DEF_ID = cat_def.ID;

From an application logic perspective, this table is queried whenever the system needs to determine if a particular business object (like a customer record) is a valid target for a set of eligibility checks before those rules are executed. This prevents runtime errors and ensures data integrity. Reporting use cases typically involve auditing the configuration of eligibility frameworks to ensure all necessary object classes are mapped for operational criteria categories.

Related Objects

OKL_FE_CRIT_CAT_OBJECTS is centrally connected to other key tables in the OKL eligibility engine, as documented by its foreign key relationship.

  • OKL_FE_CRIT_CAT_DEF_B: This is the primary related table. The foreign key OKL_FE_CRIT_CAT_OBJECTS.CRIT_CAT_DEF_ID references this table, which holds the base definitions and names for eligibility criteria categories. Any join to retrieve descriptive information for a category requires this relationship.
  • Object Class Reference: While not explicitly listed in the provided metadata, the OBJECT_CLASS_ID column typically references a lookup or code table (such as FND_LOOKUP_VALUES or a module-specific object class table) that defines the valid business entity types within OKL.