Results for “reporting_product”

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

Overview

The OKL_LEASE_PRODUCTS_UV view is a user interface and reporting view within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It presents lease product definitions together with their associated quality parameters, exposing a denormalized, human-readable representation of product configuration data. The view resolves coded quality values into their lookup meanings, which makes it well suited for use in OA Framework pages, concurrent program output, and ad hoc reporting where users expect descriptive labels rather than internal codes.

The suffix "_UV" conventionally indicates a user-facing view in ETRM/OKL object naming, and this object follows that convention by joining product master records with their quality value assignments. The view is owned by the APPS schema and is documented as VALID.

Underlying Base Objects

The view is defined over the following documented base objects:

• OKL_PRODUCTS (synonym) — the product master table, aliased PDT and self-joined as PDT1 to resolve the reporting product name.
• OKL_PDT_PQY_VALS (synonym) — associates products with their quality values, aliased PQV and PQV1.
• OKL_PDT_QUALITYS (synonym) — defines the quality (parameter) categories, aliased PQY and PQY1, restricted to 'LEASE' and 'TAXOWNER'.
• OKL_PQY_VALUES (synonym) — the allowed values for each quality, aliased QVE and QVE1.
• OKL_ACCOUNTING_UTIL (package) — supplies the GET_LOOKUP_MEANING function used to translate coded values into descriptive meanings.

The joins are outer joins (noted by the (+) operator), so a product without a lease-deal-type or tax-owner quality assignment is still returned, with NULLs for the dependent columns.

Key Columns

• ID — the lease product identifier (PDT.ID), the primary key for the product.
• NAME — the product name from OKL_PRODUCTS.
• PRODUCT_SUBCLASS — the quality name associated with the product.
• DEAL_TYPE and DEAL_TYPE_MEANING — the coded lease deal type and its lookup translation.
• TAX_OWNER and TAX_OWNER_MEANING — the tax owner code and its descriptive meaning.
• REPORTING_PDT_ID — the identifier of the product designated as the reporting product; the self-join on this column via PDT1 resolves REPORTING_PRODUCT.
• REPORTING_PRODUCT — the name of the parent/reporting product to which the current product reports.
• PTL_ID, VERSION, DESCRIPTION, FROM_DATE, TO_DATE, AES_ID, OBJECT_VERSION_NUMBER, LEGACY_PRODUCT_YN — product lifecycle and attribute metadata carried through from OKL_PRODUCTS.

Common Use Cases and Queries

A frequent requirement is enumerating products and their reporting hierarchy, particularly when the reporting_pdt_id is the focus of investigation:

• Identifying which products are reporting products versus child products (REPORTING_PDT_ID IS NULL).
• Resolving descriptive labels for deal type and tax owner for presentation.
• Listing active products by date range (FROM_DATE / TO_DATE).

A representative query:

SELECT ID, NAME, PRODUCT_SUBCLASS, DEAL_TYPE_MEANING, TAX_OWNER_MEANING, REPORTING_PDT_ID, REPORTING_PRODUCT FROM APPS.OKL_LEASE_PRODUCTS_UV WHERE REPORTING_PDT_ID IS NOT NULL;

Filtering on LEGACY_PRODUCT_YN supports migration and reconciliation reporting, while VERSION and OBJECT_VERSION_NUMBER assist with change tracking.