Search Results okl_parameters_b




Overview
Explore in AI Chat

Overview

The OKL_PARAMETERS_B table is a core master data table within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. It serves as the central repository for defining parameters used in financial and operational calculations. As indicated by its description, it holds the list of parameters required by the Formulae, which are critical for processing complex lease accounting, billing, and financial analysis. This table is foundational to the configuration and execution of business rules within the OKL product family, ensuring that calculations for items such as interest, fees, and amortization are dynamic and configurable.

Key Information Stored

The table's structure is designed to uniquely identify and describe each configurable parameter. While the full column list is not detailed in the provided metadata, the documented primary and unique keys reveal the most critical fields. The ID column serves as the primary key (OKL_PARAMETERS_B_PK), providing a unique system identifier for each parameter record. The NAME column is enforced as a unique key (OKL_PMR_UK1), representing the logical, user-facing name of the parameter (e.g., 'INTEREST_RATE_BASIS', 'MINIMUM_LEASE_PAYMENT'). Typical supplementary columns in such a table would include a description, data type, active status, and creation/modification audit fields, enabling comprehensive parameter management.

Common Use Cases and Queries

This table is primarily accessed for system configuration, formula setup, and troubleshooting. Implementation consultants use it to verify available parameters when building calculation formulae. Support personnel query it to diagnose calculation errors by confirming parameter definitions. A common reporting need is to list all active parameters available for use in financial products. A typical query would be:

  • SELECT name, description FROM okl_parameters_b WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) ORDER BY name;

Another frequent operation is joining this table to function parameter mappings to understand which calculations use a specific parameter, forming the basis for impact analysis during parameter changes.

Related Objects

OKL_PARAMETERS_B has defined relationships with other key tables in the OKL schema, primarily through its primary key. As per the provided foreign key metadata:

  • OKL_FNCTN_PRMTRS_B: This table references OKL_PARAMETERS_B via the OKL_FNCTN_PRMTRS_B.PMR_ID column, which joins to the ID column of OKL_PARAMETERS_B. This relationship maps parameters to specific functions or formulae, defining which parameters are inputs to which business calculations.

Given its role, it is also logically related to various formula definition and product setup tables within the OKL module, which consume the parameter definitions stored here.