Search Results okl_question_crtrns




Overview
Explore in AI Chat

Overview

The table OKL_QUESTION_CRTRNS is a core associative entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Leasing and Finance Management (OKL) module. It functions as a relationship table that formally defines the permissible set of criteria or parameters that can be associated with specific question types. This table is fundamental to the configuration and execution of the module's business rules engine, enabling the dynamic linking of evaluative criteria to different types of questions used throughout the leasing lifecycle. Its role is to maintain the integrity of these relationships, ensuring that only valid, pre-defined criterion can be applied to a given question type during processes such as credit assessment, asset evaluation, or contract qualification.

Key Information Stored

The table's primary purpose is to store relationship keys. The most critical columns are the foreign key identifiers that link the two associated entities. The ID column serves as the unique primary key for each relationship record. The QTY_ID column holds the foreign key reference to a specific question type defined in the OKL_QUESTION_TYPES_B table. The CRN_ID column holds the foreign key reference to a specific criterion or parameter defined in the OKL_CRITERIA_B table. Together, a unique combination of QTY_ID and CRN_ID defines which criterion is allowed for a particular question type, forming the basis of the module's configurable business logic.

Common Use Cases and Queries

This table is primarily accessed for configuration validation and runtime rule resolution. A common administrative use case is querying all allowable criteria for a specific question type to set up or audit the rules engine. For example, a developer might use a query to join OKL_QUESTION_CRTRNS to OKL_QUESTION_TYPES_B and OKL_CRITERIA_B to generate a report of all configured relationships. At runtime, application logic will query this table to determine the valid set of parameters that can be presented or evaluated for a given question. A typical SQL pattern involves filtering on the QTY_ID to retrieve associated CRN_ID values.

SELECT crn_id
FROM okl_question_crtrns
WHERE qty_id = <question_type_id>;

Related Objects

OKL_QUESTION_CRTRNS is centrally linked to two key base tables via foreign key constraints, as documented in the ETRM metadata:

  • OKL_CRITERIA_B: The foreign key from column OKL_QUESTION_CRTRNS.CRN_ID references this table. It defines the master list of criteria or parameters available for association.
  • OKL_QUESTION_TYPES_B: The foreign key from column OKL_QUESTION_CRTRNS.QTY_ID references this table. It defines the master list of question types used in the system.

The table's primary key constraint, OKL_QUESTION_CRTRNS_PK on the ID column, ensures each relationship record is unique. This table is likely referenced by various application programming interfaces (APIs) and user interfaces within the OKL module that manage question and criterion setup.