Results for “okl_fe_rate_set_versions”

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

Overview

OKL_FE_RATE_SET_VERSIONS is a transaction and configuration table within the OKL (Leasing and Finance Management) module of Oracle E-Business Suite, holding versioned definitions of lease rate sets. A rate set in ETRM represents the collection of pricing parameters — interest rates, residual tolerances, payment timing indicators, and related template references — that drive rate calculation during lease origination and repricing. Each row captures a discrete, time-bounded version of a rate set, allowing the same logical rate set to evolve over time while preserving historical pricing definitions for audit and recalculation purposes. The table is populated and maintained primarily through the ETRM pricing and rate management flows rather than through direct data entry.

From a Data Vault modeling perspective, the foreign key structure suggests this object is satellite-leaning. It carries descriptive, versioned attributes belonging to a parent rate set and references several version entities (end-of-term versions, standard rate template versions, and adjustment matrix versions), which is characteristic of a satellite attached to a parent hub or link rather than a pure hub or associational link.

Key Information Stored

The table contains 38 documented columns in the 12.2.2 physical schema. The most significant attributes are:

• RATE_SET_VERSION_ID — the surrogate primary key, enforced by OKL_FE_RATE_SET_VERSIONS_PK and also by the unique index OKL_FE_RATE_SET_VERSIONS_U1. This is the column referenced by all downstream dependent tables.
• RATE_SET_ID — the parent rate set identifier, linking this version back to its owning rate set definition.
• VERSION_NUMBER — the ordinal version label distinguishing successive revisions of the same rate set.
• EFFECTIVE_FROM_DATE and EFFECTIVE_TO_DATE — the validity window during which this version applies, central to date-effective retrieval of the correct pricing version.
• LRS_RATE and STANDARD_RATE — the primary numeric pricing values used in rate calculation.
• RATE_TOLERANCE and RESIDUAL_TOLERANCE — permissible variance thresholds applied during rate and residual evaluation.
• ARREARS_YN — indicates whether payments are calculated in arrears.
• DEFERRED_PMTS and ADVANCE_PMTS — payment scheduling parameters.
• END_OF_TERM_VER_ID, STD_RATE_TMPL_VER_ID, and ADJ_MAT_VERSION_ID — foreign keys to the versioned end-of-term, standard rate template, and adjustment matrix definitions that this rate set version composes.
• STS_CODE — the status code controlling lifecycle state of the version.
• OBJECT_VERSION_NUMBER plus the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — concurrency control and auditability.

Fifteen generic ATTRIBUTE columns and ATTRIBUTE_CATEGORY provide the standard ETRM extensibility hooks.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include retrieving the currently active rate set version for a given rate set, and tracing which template versions were composited into a pricing definition.

• Active version lookup: SELECT rate_set_version_id, version_number, lrs_rate, standard_rate FROM okl_fe_rate_set_versions WHERE rate_set_id = :p_rate_set_id AND SYSDATE BETWEEN effective_from_date AND NVL(effective_to_date, SYSDATE + 1).
• Version history audit: order by version_number to reconstruct the evolution of pricing terms over time.
• Composition tracing: join to OKL_FE_EO_TERM_VERS, OKL_FE_STD_RT_TMP_VERS, and OKL_FE_ADJ_MAT_VERSIONS on their respective version ID columns to determine exactly which end-of-term, template, and adjustment definitions were used.
• Downstream impact analysis: join to OKL_FE_RATE_SET_LEVELS and OKL_LS_RT_FCTR_ENTS on RATE_SET_VERSION_ID to see tiering and rate factor entries attached to a version.

Related Objects

The most significant related objects, based on the documented foreign key relationships, are:

• OKL_FE_RATE_SET_LEVELS — references this table via RATE_SET_VERSION_ID; holds the tiered/level breakdown of the rate set version.
• OKL_LS_RT_FCTR_ENTS — references this table via RATE_SET_VERSION_ID; stores rate factor entries used in pricing calculations.
• OKL_FE_EO_TERM_VERS — referenced by END_OF_TERM_VER_ID; supplies the end-of-term version definition.
• OKL_FE_STD_RT_TMP_VERS — referenced by STD_RATE_TMPL_VER_ID; supplies the standard rate template version.
• OKL_FE_ADJ_MAT_VERSIONS — referenced by ADJ_MAT_VERSION_ID; supplies the adjustment matrix version.
• The parent rate set entity identified through RATE_SET_ID links this version table to the master rate set definition within OKL.