Search Results okl_criteria_b




Overview
Explore in AI Chat

Overview

The OKL_CRITERIA_B table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Leasing and Finance Management (OKL) module. It functions as the master repository for defining criteria parameters. As per the official documentation, these parameters, and their associated values, define the possible cases within a case set. In practical terms, this table underpins the configuration of complex business rules and decision logic used throughout the leasing lifecycle. It enables the system to evaluate conditions and determine appropriate outcomes, such as pricing calculations, contract structuring, or workflow routing, based on defined criteria.

Key Information Stored

The table's primary purpose is to store the definitional attributes of each criterion. While the full column list is not detailed in the provided metadata, the structure can be inferred from key relationships. The primary key is the ID column, uniquely identifying each criterion record. A critical foreign key is the JTF_OBJECT_CODE column, which references JTF_OBJECTS_B. This link suggests that each criterion is associated with a specific object or entity within the Oracle Applications Framework, providing context for where the criterion is applicable. Other columns would typically store the criterion's name, data type (e.g., character, number, date), and other control attributes necessary for its evaluation within a case set.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and troubleshooting of business rules. Common operational scenarios include analyzing which criteria are used in specific leasing products or diagnosing issues in contract generation logic. A frequent query pattern involves joining OKL_CRITERIA_B to its related child tables to see all configured values for a criterion. For example, to list all criteria and their associated possible answer values, one might use:

Another critical use case is tracing the relationship between a question in a questionnaire (OKL_QUESTION_CRTRNS) and the underlying criterion that defines its valid answers.

Related Objects

OKL_CRITERIA_B sits at the center of a network of related objects, as indicated by its foreign key constraints. It is referenced by several detail tables that store specific instances or values for the master criteria definitions:

  • OKL_ANSR_SET_CN_VLS: Links criteria to answer sets and constraint values.
  • OKL_CRTRN_LNSTYLS and OKL_CRTRN_SBCLSSES: Associate criteria with specific line styles and subclasses for product configuration.
  • OKL_CRTRN_USER_VALS_B: Stores the user-defined allowable values for a given criterion.
  • OKL_QUESTION_CRTRNS: Maps criteria to specific questions within questionnaires.
  • JTF_OBJECTS_B: The parent table that provides the object code context for the criterion via the JTF_OBJECT_CODE foreign key.