Results for “okl_ptq_values”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_PTQ_VALUES is a transactional configuration table within the Oracle E-Business Suite Leasing and Finance Management module (OKL). It stores the discrete values that may be attached to Template Qualities, which are subsequently consumed by the Product Template - Template Qualities setup flow during product configuration. In practical terms, the table acts as the domain-of-values repository behind each quality definition, allowing implementers to assign permissible selections, ranges, or enumerated options used when building lease and finance product templates.

From a Data Vault modeling perspective, the heuristic classification of this object is satellite-leaning. The table carries descriptive and temporal attributes (value, description, effective dates) that qualify a parent business concept rather than representing an independent hub or a pure many-to-many link. It is best treated as a descriptive satellite attached to the Template Quality entity, with the caveat that the presence of an alternate key on (PTQ_ID, VALUE) and an outbound relationship to OKL_PTL_PTQ_VALS introduces a limited linking characteristic.

Key Information Stored

The table contains twelve documented columns. The most significant are summarized below, distinguishing the surrogate key from the documented business-key candidates.

  • ID — Surrogate primary key, enforced by the OKL_PTQ_VALUES_PK constraint and the unique index OKL_PTQ_VALUES_U1. Used as the internal row identifier and referenced by dependent tables.
  • PTQ_ID — Foreign key to OKL_PTL_QUALITYS, identifying the parent Template Quality to which the value belongs.
  • VALUE — The actual value attached to the Template Quality. Together with PTQ_ID it forms the alternate unique key OKL_PTQ_VALUES_U2, preventing duplicate values within the same quality.
  • DESCRIPTION — Free-text description of the value, typically surfaced in setup and lookup screens.
  • FROM_DATE and TO_DATE — Effective dating for the value, supporting date-tracked configuration changes.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the EBS framework to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle Applications audit columns capturing who created or last modified the row and when.

Common Use Cases and Queries

Typical uses center on product setup validation, configuration reporting, and troubleshooting missing or duplicate template quality values.

  • Listing all values defined for a specific Template Quality:
    SELECT ptv.id, ptv.value, ptv.description,
           ptv.from_date, ptv.to_date
    FROM   okl.okl_ptq_values ptv
    WHERE  ptv.ptq_id = :ptq_id
    ORDER  BY ptv.value;
  • Joining values to their parent quality to produce a setup worksheet for product template review.
  • Detecting duplicate value assignments, which the unique index OKL_PTQ_VALUES_U2 should prevent, as part of data quality audits.
  • Historical analysis using FROM_DATE and TO_DATE to reconstruct which values were active at a given point in time.
  • Reporting on recent configuration activity via CREATION_DATE and LAST_UPDATE_DATE for change management purposes.

Related Objects

The following objects are most significant in relation to OKL_PTQ_VALUES, based on the documented FK and PK relationships.

  • OKL_PTL_QUALITYS — Parent table of Template Qualities; joined via OKL_PTQ_VALUES.PTQ_ID = OKL_PTL_QUALITYS.PTQ_ID (or its primary key).
  • OKL_PTL_PTQ_VALS — Dependent table referencing OKL_PTQ_VALUES through PTV_ID, linking these values into product template value usage.
  • OKL_PTQ_VALUES_PK — Primary key constraint on ID.
  • OKL_PTQ_VALUES_U1 — Unique index on ID.
  • OKL_PTQ_VALUES_U2 — Unique index on (PTQ_ID, VALUE), the documented business-key candidate.

These relationships support the Product Template setup process, where qualities and their permissible values drive downstream product definition and pricing logic.