Search Results okl_fe_rate_set_versions_v




Overview
Explore in AI Chat

Overview

OKL_FE_RATE_SET_VERSIONS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL - Lease and Finance Management (formerly Oracle Lease Management / ETRM) product family. The view exposes lease rate set versioning data and carries a documented status of VALID in releases 12.1.1 and 12.2.2. Its description, "Lease Rate Set Versions View," indicates that it surfaces the versioned records that define the financial terms applied when pricing a lease contract, including rates, tolerances, and the timing conventions governing payment streams.

Users searching for adj_mat_version_id arrive at this object because that column is one of the version-reference attributes exposed by the view. ADJ_MAT_VERSION_ID links a rate set version to the adjustment maturity template version in effect, allowing pricing and contract authoring logic to resolve the correct maturity/adjustment ruleset. Because the view is a straight projection over the base rate set versions entity, it is commonly consumed by inquiry screens, concurrent programs, and external integrations that need a stable, read-only interface to rate set version metadata without querying the underlying table directly.

Underlying Base Objects

The view is defined over a single base object, OKL_FE_RATE_SET_VERSIONS, referenced through a synonym in the APPS schema. The view text performs no joins, aggregations, or filters; it is a pure column projection using an explicit SELECT list that names every exposed column. Consequently, row cardinality and column semantics are identical to the base table, and all DML and validation remain the responsibility of the underlying entity. The object versioning control column, OBJECT_VERSION_NUMBER, supports Oracle's optimistic locking conventions for the underlying records.

Key Columns

Common Use Cases and Queries

Typical scenarios include retrieving all versions of a given rate set, resolving the adjustment maturity template version for pricing validation, and extracting rate and tolerance parameters for reporting or downstream integration. Because the view is unfiltered, queries should constrain by STATUS, effective dates, or parent identifiers to limit result sets.

  • Resolve adjustment maturity template versions: SELECT rate_set_version_id, rate_set_id, adj_mat_version_id, version_number FROM okl_fe_rate_set_versions_v WHERE adj_mat_version_id IS NOT NULL;
  • List active versions for a rate set: SELECT version_number, effective_from_date, effective_to_date, lrs_rate, sts_code FROM okl_fe_rate_set_versions_v WHERE rate_set_id = :p_rate_set_id ORDER BY version_number;
  • Audit recently changed versions: SELECT rate_set_version_id, last_updated_by, last_update_date FROM okl_fe_rate_set_versions_v WHERE last_update_date >= :p_since;

All reporting against this view is read-only; inserts and updates must target the underlying OKL_FE_RATE_SET_VERSIONS entity through supported application program interfaces or concurrent processes to preserve versioning and audit integrity.