Search Results okl_k_rate_params_u1

Overview

OKL.OKL_K_RATE_PARAMS is a transaction table in the Oracle E-Business Suite Lease Management (OKL) schema that stores interest rate parameters associated with lease contracts. The table resides in the APPS_TS_TX_DATA tablespace and is designated as VALID in ETRM 12.1.1 and 12.2.2. Its primary role is to define how interest is calculated on a lease contract across time, capturing base rates, adder rates, floors and ceilings, compounding conventions, catch-up rules, rate change schedules, and conversion options. Because rate terms frequently change over the life of a lease, each row is time-stamped by an effective date, allowing the application to resolve the correct rate terms as of any given accounting or billing date.

From a heuristic Data Vault modeling perspective, this object behaves as a satellite: its grain is the combination of contract, parameter type, and effective date, and it carries descriptive, time-variant attributes (rates, codes, dates) that describe a parent contract. It may also be modeled as a link if the interest index and calculation formula references are treated as independent business keys.

Key Information Stored

The document records 49 columns. The most significant are summarized below.

• KHR_ID — the contract identifier linking the rate parameters to a lease contract header.
• PARAMETER_TYPE_CODE — distinguishes rate parameter sets, such as Actual versus Conversion.
• EFFECTIVE_FROM_DATE / EFFECTIVE_TO_DATE — the validity window for the rate terms.
• INTEREST_INDEX_ID — reference to the interest index used to derive the floating portion of the rate.
• BASE_RATE, ADDER_RATE — the core rate components combined to arrive at the applied interest rate.
• MINIMUM_RATE, MAXIMUM_RATE — floors and caps applied after rate calculation.
• PRINCIPAL_BASIS_CODE — the balance basis against which interest is assessed.
• DAYS_IN_A_MONTH_CODE / DAYS_IN_A_YEAR_CODE / INTEREST_BASIS_CODE — day-count and interest-basis conventions.
• COMPOUNDING_FREQUENCY_CODE — how often interest is compounded.
• RATE_CHANGE_START_DATE, RATE_CHANGE_FREQUENCY_CODE, RATE_CHANGE_VALUE — scheduled rate changes.
• CONVERSION_OPTION_CODE, NEXT_CONVERSION_DATE, CONVERSION_TYPE_CODE — lease conversion terms.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the descriptive flexfield segment used to capture client-specific rate attributes.

The surrogate identifier is documented as OKL_K_RATE_PARAMS_PK, composed of PARAMETER_TYPE_CODE, EFFECTIVE_FROM_DATE, and KHR_ID. The unique index OKL_K_RATE_PARAMS_U1 (KHR_ID, PARAMETER_TYPE_CODE, EFFECTIVE_FROM_DATE) is the business-key candidate, located in the APPS_TS_TX_IDX tablespace. The user search on "okl_k_rate_params_u1" therefore targets the uniqueness guarantee that no two active rate-parameter rows overlap for the same contract and parameter type.

Common Use Cases and Queries

Typical uses include rate validation audits, interest recalculation, lease modification impact analysis, and conversion scheduling. A representative query resolves the effective rate row for a contract at a point in time:

SELECT khr_id, parameter_type_code, base_rate, adder_rate,
       maximum_rate, minimum_rate, effective_from_date, effective_to_date
FROM   okl.okl_k_rate_params
WHERE  khr_id = :p_khr_id
AND    parameter_type_code = 'ACTUAL'
AND    :p_eff_date BETWEEN effective_from_date
                       AND NVL(effective_to_date, :p_eff_date);

Reporting queries often join these rows to interest index and formula references, aggregate rate changes over a period, or flag rows where MINIMUM_RATE exceeds MAXIMUM_RATE. Conversion option analysis uses NEXT_CONVERSION_DATE and CONVERSION_TYPE_CODE.

Related Objects

The table is classified as standalone in the mined FK structure, so no formal foreign keys are documented. Functionally it relates to:

• OKL_K_HEADERS — joined on KHR_ID, providing the parent contract.
• OKL_INTEREST_INDEXES — referenced by INTEREST_INDEX_ID.
• OKL_CALC_FORMULAS / calculation formula definitions — referenced by CALCULATION_FORMULA_ID.
• OKL_K_LINES — contract lines whose interest derives from these parameters.
• OKL_K_RATE_PARAMS interfaces / concurrent programs — used to import rate changes and conversion schedules into EBS.