Search Results okl_pdt_opt_vals




Overview
Explore in AI Chat

Overview

The OKL_PDT_OPT_VALS table is a core data object within the Oracle E-Business Suite (EBS) module for Lease and Finance Management (OKL). It serves as a junction or association table, establishing the critical link between product options (OKL_PDT_OPTS) and their permissible values (OKL_OPT_VALUES). Its primary role is to define the valid value set for a specific option associated with a product, enabling the configuration of flexible lease and finance products. This table is essential for maintaining data integrity in the product setup hierarchy, ensuring that only predefined values can be selected when configuring a contract.

Key Information Stored

The table's structure is designed to manage the many-to-many relationships between options and their values. The key columns include the primary key ID, which uniquely identifies each association record. The foreign key column PON_ID references the product option (OKL_PDT_OPTS), and the foreign key column OVE_ID references the specific option value (OKL_OPT_VALUES). The unique key constraint POV_POV_UK on the combination of OVE_ID and PON_ID ensures that a given option value cannot be redundantly assigned to the same product option.

Common Use Cases and Queries

A primary use case is validating and presenting available choices during contract booking or product configuration. For instance, when a user selects a product option like "Payment Frequency," the application queries OKL_PDT_OPT_VALS to retrieve all associated valid values (e.g., Monthly, Quarterly, Annually) from OKL_OPT_VALUES. A common reporting query involves listing all configurable options and their allowed values for a specific product.

Sample Query: To find all permissible values for a specific product option (identified by PON_ID):

SELECT ov.meaning, ov.description
FROM okl_opt_values ov,
     okl_pdt_opt_vals pov
WHERE pov.ove_id = ov.id
  AND pov.pon_id = <product_option_id>;

Related Objects

The table is central to the product option data model, with the following documented foreign key relationships:

  • References (Parent Tables):
    • OKL_OPT_VALUES: Linked via OKL_PDT_OPT_VALS.OVE_ID = OKL_OPT_VALUES. This provides the descriptive value (e.g., "Monthly").
    • OKL_PDT_OPTS: Linked via OKL_PDT_OPT_VALS.PON_ID = OKL_PDT_OPTS. This defines the product option itself (e.g., "Payment Frequency").
  • Referenced By (Child Table):
    • OKL_SLCTD_OPTNS: Linked via OKL_SLCTD_OPTNS.POV_ID = OKL_PDT_OPT_VALS.ID. This table stores the specific value chosen for an option on an actual lease or finance contract, making OKL_PDT_OPT_VALS the source of valid choices.