Search Results okl_ansr_set_cn_vls




Overview
Explore in AI Chat

Overview

The table OKL_ANSR_SET_CN_VLS is a core data dictionary object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module, specifically in versions 12.1.1 and 12.2.2. It functions as a validation table that defines the permissible values, or "arguments," that a given CRITERION can accept. This table is integral to the configuration and execution of business rules and decision logic within the leasing application, ensuring data integrity by restricting criterion inputs to a predefined, valid set of values. Its role is foundational to the Answer Set and Criteria framework, which is used to model complex business conditions and scoring mechanisms.

Key Information Stored

The table's primary purpose is to map criteria to their allowed values. While the full column list is not detailed in the provided metadata, the documented foreign key relationships and primary key reveal its critical structure. The primary key column is ID (OKL_ANSR_SET_CN_VLS_PK). Two essential foreign key columns establish its relationships: ASR_ID links to an Answer Set Criterion (OKL_ANSR_SET_CRTRIA_B), and CRN_ID links to the master definition of the Criterion itself (OKL_CRITERIA_B). Each record effectively states that for a specific criterion (CRN_ID) within a specific answer set context (ASR_ID), a particular value (implied by the record's existence and potentially a VALUE column) is valid.

Common Use Cases and Queries

This table is primarily accessed for configuration validation and runtime rule evaluation. A common use case is during the setup of leasing decision rules, where an administrator needs to view or maintain the list of acceptable inputs for a criterion like "Customer Credit Tier" or "Asset Type." For reporting and troubleshooting, a typical query would join this table to its parent tables to get descriptive information. For example:

  • To list all allowed values for criteria within a specific answer set:
    SELECT crn.NAME, vls.* FROM OKL_ANSR_SET_CN_VLS vls, OKL_CRITERIA_B crn WHERE vls.CRN_ID = crn.ID AND vls.ASR_ID = :p_asr_id;
  • To validate if a user-provided input is permissible for a given criterion during a business process.

Related Objects

The table sits at the center of a key relationship hierarchy in the OKL module, as per the documented foreign keys:

  • Referenced by OKL_ANSR_SET_CN_VLS (Foreign Keys Out):
    • OKL_ANSR_SET_CRTRIA_B via column ASR_ID. This links a valid value to its parent Answer Set Criterion record.
    • OKL_CRITERIA_B via column CRN_ID. This links the value to the master definition of the criterion.
  • Referencing OKL_ANSR_SET_CN_VLS (Foreign Keys In):
    • OKL_ANSR_CRTRN_VALS references this table via its ASV_ID column. This indicates that the actual stored values for criteria (likely in transactional data) must be one of the allowed values defined in OKL_ANSR_SET_CN_VLS.