Search Results okl_pdt_opts




Overview
Explore in AI Chat

Overview

The OKL_PDT_OPTS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the OKL (Lease and Finance Management) product family. Its primary function is to manage the association between financial products and their configurable options. This table acts as a junction or intersection entity, enabling a many-to-many relationship between products (defined in OKL_PRODUCTS) and the available options (defined in OKL_OPTIONS). This structure is fundamental for product configuration, allowing a single product to be linked to multiple options and a single option to be available for multiple products, thereby supporting complex and flexible leasing and financing product offerings.

Key Information Stored

The table's structure is designed to establish and maintain the product-option relationship. The key columns include a unique identifier and the foreign keys that link to the parent tables. Based on the provided metadata, the critical columns are:

  • ID: The primary key column for the table, uniquely identifying each product-option association record.
  • PDT_ID: A foreign key column referencing the OKL_PRODUCTS table. This identifies the specific leasing or financing product to which an option is attached.
  • OPT_ID: A foreign key column referencing the OKL_OPTIONS table. This identifies the specific configurable option being associated with a product.

The table also enforces a unique constraint (PON_PON_UK) on the combination of OPT_ID and PDT_ID, ensuring that the same option cannot be linked to the same product more than once.

Common Use Cases and Queries

This table is central to queries that determine what options are available for a given product or which products offer a specific option. Common scenarios include generating product catalogs with available features, validating user selections during contract booking, and reporting on product option utilization. A typical query would join OKL_PDT_OPTS with OKL_PRODUCTS and OKL_OPTIONS to list all options for a product.

SELECT prod.name AS product_name,
       opt.name AS option_name
FROM okl. okl_pdt_opts pon,
     okl. okl_products prod,
     okl. okl_options opt
WHERE pon.pdt_id = prod.id
  AND pon.opt_id = opt.id
  AND prod.id = :p_product_id;

Another critical use case involves the creation or validation of option values for a specific contract, as the OKL_PDT_OPT_VALS table stores actual values for the associations defined here.

Related Objects

The OKL_PDT_OPTS table is a pivotal link in the product configuration data model, with documented relationships to several key OKL tables.

  • OKL_PRODUCTS: The parent table for products. Joined via OKL_PDT_OPTS.PDT_ID = OKL_PRODUCTS.ID.
  • OKL_OPTIONS: The parent table for configurable options. Joined via OKL_PDT_OPTS.OPT_ID = OKL_OPTIONS.ID.
  • OKL_PDT_OPT_VALS: A key child table. It stores the specific values assigned to a product-option association for an actual contract or agreement. Joined via OKL_PDT_OPT_VALS.PON_ID = OKL_PDT_OPTS.ID.