Search Results okl_k_rate_params_v




Overview
Explore in AI Chat

Overview

The view APPS.OKL_K_RATE_PARAMS_V is a reporting and integration construct within the Oracle E-Business Suite (EBS) Leasing and Finance Management module (product code OKL). It exposes the configuration parameters that govern variable interest rate processing for lease and finance contracts. In EBS 12.1.1 and 12.2.2, OKL supports both fixed and variable rate instruments; this view surfaces the variable rate definitions, including the reference interest index, the base rate, additive spreads, and the numerous basis and frequency codes that determine how interest is accrued, compounded, delayed, and reset over the life of an agreement.

The view is owned by the APPS schema and is reported as VALID. Its stated purpose is to present Variable Rate Parameters, which makes it a natural source for both internal reporting and inbound/outbound integrations that need to read the parameters driving rate calculations rather than write them. Because it is a view rather than a base table, it provides an abstraction layer over the underlying leasing rate configuration table, giving consumers a stable, named interface for querying rate behaviour.

Underlying Base Objects

According to the documented ETRM metadata for 12.2.2, OKL_K_RATE_PARAMS_V is defined over a single referenced base object: the synonym OKL_K_RATE_PARAMS. The view text confirms this with a straight projection from the table aliased KRP:

  • FROM OKL_K_RATE_PARAMS KRP — the synonym resolves to the underlying OKL rate parameters table in the APPS schema.
  • The view performs no joins, unions, or aggregations; it is a column-renaming projection that applies the ROWID trick (exposing ROWID as ROW_ID) and aliases each source column to a consistent public name.
  • Because it is a simple one-to-one projection, each row in the view corresponds to exactly one row in OKL_K_RATE_PARAMS, and row identity/version is preserved through KHR_ID.

Key Columns

The view exposes a comprehensive set of rate-definition columns. The most significant, grouped by function, are:

Common Use Cases and Queries

Typical uses include extracting variable rate schedules for reconciliation, validating base rate configuration during implementations, and feeding downstream pricing or treasury reports. A representative query targeting the searched term is:

  • SELECT khr_id, base_rate, adder_rate, minimum_rate, maximum_rate, effective_from_date, effective_to_date FROM apps.okl_k_rate_params_v WHERE base_rate IS NOT NULL ORDER BY effective_from_date;
  • SELECT interest_index_id, base_rate, parameter_type_code FROM apps.okl_k_rate_params_v WHERE SYSDATE BETWEEN effective_from_date AND NVL(effective_to_date, SYSDATE);

Because the view is a direct projection of OKL_K_RATE_PARAMS, joins to INTEREST_INDEX_ID or to lease header records are performed by the consuming query rather than within the view itself.