Search Results okl_ansr_set_crtria_b




Overview
Explore in AI Chat

Overview

The OKL_ANSR_SET_CRTRIA_B table is a core data entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the OKL (Leasing and Finance Management) product family. As documented in the ETRM, its primary function is to serve as the "Link between Questions and Answer Sets." This table acts as a junction or intersection table within the application's data model, establishing and managing the relationships between defined questions and the sets of possible answers (criteria) that can be provided. Its role is critical for configuring and processing business rules, validations, and decision logic that depend on user or system-provided answers within the leasing and finance workflows.

Key Information Stored

While the provided metadata does not list individual columns, the documented primary and foreign key relationships reveal the essential data points stored. The table's primary key is the ID column, which uniquely identifies each link record. A crucial foreign key is the ANT_ID column, which references the OKL_ANSWER_SETS_B table, thereby identifying the specific answer set involved in the relationship. The table's purpose as a link suggests it also contains a foreign key to a questions table (not explicitly listed in the provided snippet but logically required, such as OKL_QUESTION_TEMPLATES_B). This structure allows the system to associate a single question with multiple answer criteria sets or vice versa, enabling complex, configurable business logic.

Common Use Cases and Queries

This table is central to scenarios where business processes are driven by questionnaire-style inputs. Common use cases include credit assessment setups, lease qualification checklists, and asset evaluation criteria where responses must be validated against predefined acceptable values. For reporting and troubleshooting, typical queries involve joining this table to related entities to analyze configured rules. A fundamental SQL pattern retrieves all answer sets linked to a specific question template:

  • SELECT ast.* FROM OKL_ANSWER_SETS_B ast, OKL_ANSR_SET_CRTRIA_B lnk WHERE lnk.ANT_ID = ast.ID AND lnk.QUESTION_ID = :p_question_id;

Conversely, queries often identify all questions governed by a particular answer set for impact analysis during configuration changes.

Related Objects

The OKL_ANSR_SET_CRTRIA_B table is integral to a network of related objects, as confirmed by the provided foreign key metadata.

  • Referenced Table (Parent): The table holds a foreign key to OKL_ANSWER_SETS_B (ANT_ID), making it a child record of a defined answer set.
  • Referencing Tables (Children): Two key tables have foreign keys pointing back to the ID column of OKL_ANSR_SET_CRTRIA_B, establishing it as a parent:
    • OKL_ANSR_CRTRN_VALS (ASR_ID): This table likely stores the individual permissible answer values or criteria for the linked set.
    • OKL_ANSR_SET_CN_VLS (ASR_ID): This table potentially stores conditional values or additional attributes dependent on the specific question-answer set link.

This relationship structure positions OKL_ANSR_SET_CRTRIA_B as a critical hub, connecting the definition of an answer set (OKL_ANSWER_SETS_B) to its detailed criteria values and to the specific questions it evaluates.