Search Results okl_ansr_crtrn_vals_pk

Overview

The table OKL_ANSR_CRTRN_VALS is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. Its primary function is to establish a formal association between a specific CASE and a particular combination of allowed values for a defined CRITERION. This table acts as a junction or intersection entity, linking the master definition of an answer set (CASE) with the specific criteria values that must be satisfied. It is a critical component in the configuration and execution of rule-based or criteria-driven processes within the leasing and finance lifecycle, enabling the system to evaluate conditions and determine applicable business logic based on stored value combinations.

Key Information Stored

The table's structure is designed to manage these associations through a set of key identifier columns. The primary technical identifier is the ID column, which serves as the primary key (OKL_ANSR_CRTRN_VALS_PK). From a functional perspective, the table is uniquely constrained by the combination of AWR_ID and ASR_ID (constraint ACV_ACV_UK). The AWR_ID column holds the foreign key reference to the OKL_ANSWERS table, identifying the specific answer or case. The ASR_ID column references the OKL_ANSR_SET_CRTRIA_B table, linking to the allowed criterion definition. Finally, the ASV_ID column references the OKL_ANSR_SET_CN_VLS table, which stores the specific allowed value for the linked criterion. Together, these columns record that for a given answer (AWR_ID), a specific criterion (ASR_ID) is satisfied by a particular value (ASV_ID).

Common Use Cases and Queries

This table is central to scenarios requiring dynamic configuration based on multiple business criteria. A primary use case is in product qualification or contract validation workflows, where a lease product (CASE) is only applicable if a set of customer or asset attributes matches defined criteria values. For reporting and troubleshooting, common queries involve joining to related tables to see the full context of a rule. For example, to list all value associations for a specific answer set, one might use:

• SELECT acv.awr_id, acv.asr_id, acv.asv_id, crt.name, vl.value
• FROM okl_ansr_crtrn_vals acv,
• okl_ansr_set_crtria_b crt,
• okl_ansr_set_cn_vls vl
• WHERE acv.asr_id = crt.id
• AND acv.asv_id = vl.id
• AND acv.awr_id = :p_answer_id;

Data integrity checks, such as identifying associations with invalid foreign key references, are also frequent administrative queries.

Related Objects

OKL_ANSR_CRTRN_VALS is a dependent table with well-defined relationships to three key parent tables in the OKL schema, as documented in the ETRM metadata:

• OKL_ANSWERS: Linked via the foreign key column OKL_ANSR_CRTRN_VALS.AWR_ID. This is the master table for the answer or case being configured.
• OKL_ANSR_SET_CRTRIA_B: Linked via the foreign key column OKL_ANSR_CRTRN_VALS.ASR_ID. This table defines the allowable criteria or conditions.
• OKL_ANSR_SET_CN_VLS: Linked via the foreign key column OKL_ANSR_CRTRN_VALS.ASV_ID. This table stores the discrete allowed values for the criteria defined in OKL_ANSR_SET_CRTRIA_B.

These relationships form a logical chain from the high-level case (ANSWERS) down to the specific permissible value (SET_CN_VLS) for a given criterion (SET_CRTRIA_B), with OKL_ANSR_CRTRN_VALS providing the essential associative link.