Search Results okl_fe_rate_set_versions




Overview
Explore in AI Chat

Overview

The OKL_FE_RATE_SET_VERSIONS table is a core data object within the Oracle E-Business Suite (EBS) module OKL (Lease and Finance Management). It serves as the master repository for versioned lease rate sets. In the context of financial engineering, a rate set defines the specific interest rates, indexes, margins, and adjustment factors applicable to a lease or financing agreement. This table manages the evolution of these rate sets over time, enabling the system to maintain a historical record of rate definitions. This versioning capability is critical for accurate financial calculations, audit trails, and compliance, particularly for long-term contracts where underlying rate terms may be updated or amended. Its role is integral to the pricing and revenue recognition processes within the Oracle Lease Management suite for both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary identifier is the RATE_SET_VERSION_ID, which uniquely defines each version of a rate set. The table's structure establishes critical relationships through foreign key columns that link a rate set version to its parent definition and associated calculation components. The RATE_SET_ID column ties the version back to its master rate set header. Furthermore, the table links to specific versions of other financial engineering objects: END_OF_TERM_VER_ID references a version of end-of-term options, STD_RATE_TMPL_VER_ID links to a standard rate template version, and ADJ_MAT_VERSION_ID connects to an adjustment matrix version. This design ensures that a complete, point-in-time snapshot of all interrelated pricing components is preserved with each rate set version.

Common Use Cases and Queries

A primary use case is retrieving the complete, effective rate set configuration for a specific lease contract as of a given date for financial calculations or reporting. Developers and analysts may query this table to audit rate changes over the life of an agreement or to troubleshoot pricing discrepancies. Common SQL patterns involve joining to related version tables to reconstruct a full rate definition.

  • Finding all versions for a specific rate set:
    SELECT * FROM OKL.OKL_FE_RATE_SET_VERSIONS WHERE RATE_SET_ID = <id> ORDER BY RATE_SET_VERSION_ID;
  • Identifying the current active version for a contract's rate set, often by joining with the lease header or rate set assignment tables and filtering by effective dates.
  • Reporting on the historical components linked to a rate set version by joining with OKL_FE_EO_TERM_VERS, OKL_FE_STD_RT_TMP_VERS, and OKL_FE_ADJ_MAT_VERSIONS tables.

Related Objects

The OKL_FE_RATE_SET_VERSIONS table is a central hub within the financial engineering schema. It is referenced by child tables that store detailed rate information, such as OKL_FE_RATE_SET_LEVELS (for tiered or leveled rates) and OKL_LS_RT_FCTR_ENTS (for lease rate factor entries). As indicated by its foreign keys, it has direct dependencies on specific versions of related template objects: OKL_FE_EO_TERM_VERS (End of Term Versions), OKL_FE_STD_RT_TMP_VERS (Standard Rate Template Versions), and OKL_FE_ADJ_MAT_VERSIONS (Adjustment Matrix Versions). The parent table for the rate set header (OKL_FE_RATE_SETS) is also a key related object, though not explicitly listed in the provided metadata.