Search Results okl_opt_values




Overview
Explore in AI Chat

Overview

The OKL_OPT_VALUES table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Lease and Finance Management (OKL) module. It functions as a master repository for the permissible values that can be assigned to configurable options within lease and finance contracts. This table is essential for enforcing data integrity and business rules, as it defines the valid domain of values for specific contract options, ensuring that only pre-defined, approved entries are selected during contract configuration and processing.

Key Information Stored

The table's primary purpose is to store the relationship between an option and its valid values. Key columns include the primary key ID, which uniquely identifies each value record. The OPT_ID column is a foreign key that links the value to its parent option definition in the OKL_OPTIONS table. The VALUE column holds the actual permissible entry for the option, such as a specific term, rate, or feature code. The unique key constraint OVE_OVE_UK on OPT_ID and VALUE ensures that duplicate values cannot be defined for the same option.

Common Use Cases and Queries

A primary use case is validating user input during the setup or amendment of a lease contract. When a user selects an option, the application queries OKL_OPT_VALUES to present a validated list of choices. For reporting and analysis, this table is joined to contract line details to analyze the prevalence of specific option values. Common SQL patterns include fetching all valid values for a given option or checking if a proposed entry is valid.

  • Retrieve all permissible values for a specific option ID: SELECT value FROM okl_opt_values WHERE opt_id = <option_id> ORDER BY value;
  • Validate a proposed option value during data entry: SELECT 'VALID' FROM dual WHERE EXISTS (SELECT 1 FROM okl_opt_values WHERE opt_id = <option_id> AND value = <proposed_value>);

Related Objects

OKL_OPT_VALUES sits at the center of a key data model for contract options. It has defined foreign key relationships with several other critical tables in the OKL schema, as documented in the ETRM metadata.

  • References (Parent): OKL_OPTIONS table via OKL_OPT_VALUES.OPT_ID = OKL_OPTIONS.<key>. This defines the option to which the value belongs.
  • Referenced By (Children):
    • OKL_OPV_RULES table via OKL_OPV_RULES.OVE_ID = OKL_OPT_VALUES.ID. This links the option value to specific business rules.
    • OKL_PDT_OPT_VALS table via OKL_PDT_OPT_VALS.OVE_ID = OKL_OPT_VALUES.ID. This associates the permissible value with product definitions.