Search Results okl_products




Overview
Explore in AI Chat

Overview

The OKL_PRODUCTS table is a core master data table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It serves as the central repository for defining financial products, which are essentially templates that govern the financial treatment, accounting rules, and structural options for lease and finance contracts. When a user creates a contract or quote in the system, they select a specific product, which then dictates the applicable accounting templates, pricing models, charge setups, and other financial rules. This table is fundamental to ensuring consistent and automated financial processing across all leasing transactions.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and unique key constraints highlight the most critical attributes. Each product is uniquely identified by a system-generated ID (primary key). The combination of NAME and VERSION must also be unique, allowing for version control of product definitions over time. The table stores foreign key references to other master data objects, notably the AES_ID (linking to accounting event setup templates in OKL_AE_TMPT_SETS_ALL) and the PTL_ID (linking to product templates in OKL_PDT_TEMPLATES). A self-referential foreign key on REPORTING_PDT_ID allows a product to be associated with a separate reporting product, enabling complex consolidation and reporting scenarios.

Common Use Cases and Queries

This table is primarily referenced during the contract entry and configuration processes. Common operational and reporting queries include listing all active financial products for a user to select, validating product setup, and tracing financial rules. For example, to retrieve a list of products with their linked accounting template, a query might join to OKL_AE_TMPT_SETS_ALL. A critical reporting use case involves analyzing all contracts or quotes based on their underlying product to assess profitability or risk by product type. A basic query pattern is:

  • SELECT p.name, p.version, a.template_name FROM okl_products p, okl_ae_tmpt_sets_all a WHERE p.aes_id = a.id ORDER BY p.name;

Data from this table is typically maintained via the Oracle E-Business Suite application's product definition forms, not via direct SQL manipulation.

Related Objects

As evidenced by the extensive foreign key relationships, OKL_PRODUCTS is a central hub in the OKL schema. Key documented relationships include:

  • OKL_AE_TMPT_SETS_ALL: Joined via OKL_PRODUCTS.AES_ID. Defines the accounting rules for the product.
  • OKL_PDT_TEMPLATES: Joined via OKL_PRODUCTS.PTL_ID. Provides the structural template for the product.
  • OKL_TRX_CONTRACTS / OKL_TRX_CONTRACTS_ALL: Joined via PDT_ID. All contracts are instantiated from a product.
  • OKL_TRX_QUOTES_B / OKL_TRX_QUOTES_ALL_B: Joined via PDT_ID. All quotes are based on a product.
  • OKL_PDT_OPTS & OKL_PDT_PQY_VALS: Joined via PDT_ID. Store configurable options and pricing qualifiers for the product.
  • OKL_LTE_CHRG_SETUPS & OKL_LS_RT_FCTR_SETS_B: Joined via PDT_ID. Define charge setups and rate factor sets applicable to the product.
  • OKL_PRODUCTS (Self-Referential): Joined via OKL_PRODUCTS.REPORTING_PDT_ID. Links a product to a separate reporting product definition.