Search Results okl_pdt_qualitys




Overview
Explore in AI Chat

Overview

The OKL_PDT_QUALITYS table is a core reference table within the Oracle E-Business Suite (EBS) module OKL (Lease and Finance Management). It functions as the master repository for defining product qualities, which are configurable attributes or characteristics that can be assigned to financial products. During the setup of a product template, administrators select from these predefined qualities to model the specific features and behaviors of lease or finance products. This table enables the standardization and consistent application of product attributes across the leasing portfolio, forming a foundational element of the product configuration framework.

Key Information Stored

The table stores the master definitions for each product quality. While the full column list is not detailed in the provided metadata, the primary and unique key constraints highlight the most critical fields. The ID column serves as the system-generated primary key (PK), uniquely identifying each quality record. The NAME column holds the unique, user-defined name or code for the product quality, such as 'RESIDUAL_VALUE_CALC_METHOD' or 'LEASE_TERM_BASIS'. Additional columns likely exist to store descriptive information, data types, validation rules, and active status flags for each quality, supporting the product template setup process.

Common Use Cases and Queries

The primary use case is the administration and inquiry of configurable product attributes during financial product design. A system administrator may query this table to review or maintain the list of available qualities before applying them to a template. Common reporting needs include listing all active qualities or finding a specific quality by name for troubleshooting. Sample SQL patterns include:

  • Basic retrieval: SELECT id, name FROM okl.oKL_pdt_qualitys WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY name;
  • Validation query: SELECT COUNT(*) FROM okl.oKL_pdt_qualitys WHERE name = '<Quality_Name>';

These qualities are subsequently assigned values within specific product templates, driving the detailed configuration of lease agreements.

Related Objects

OKL_PDT_QUALITYS is central to the product configuration data model, with two key foreign key relationships documented in the ETRM:

  • OKL_PDT_PQYS: This table links product qualities to product templates. The foreign key column OKL_PDT_PQYS.PQY_ID references OKL_PDT_QUALITYS.ID, establishing which qualities are assigned to a given template.
  • OKL_PQY_VALUES: This table stores the specific values for a quality within a product template. The foreign key column OKL_PQY_VALUES.PQY_ID references OKL_PDT_QUALITYS.ID, connecting the value instance back to its master definition.

These relationships illustrate the data flow: a quality is defined in OKL_PDT_QUALITYS, assigned to a template via OKL_PDT_PQYS, and given a concrete value in OKL_PQY_VALUES.