Search Results okl_fe_rate_set_levels_v




Overview
Explore in AI Chat

Overview

OKL_FE_RATE_SET_LEVELS_V is a reporting view in the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module, owned by the APPS schema. It is documented as the "Lease Rate Factor Levels View" and carries a status of VALID within the ETRM data model. The view exposes the level or tier structure that underpins a lease rate set, presenting the individual rows that define how a lease rate factor varies across defined period ranges and residual percentages.

In leasing and finance management, rate sets are used to derive lease rate factors or pricing terms based on contract attributes such as term length and residual value. The view provides a flattened, read-consistent projection of these level definitions for reporting and integration purposes. It is part of the surrounding family of OKL_FE (Finance/Feasibility Engine) views and tables that support rate set processing in ETRM 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a single base object, OKL_FE_RATE_SET_LEVELS, which is referenced through a synonym. The view text is a straightforward projection of all columns from that base table:

  • SELECT list mirrors the base table columns exactly, with no joins, filters, or aggregation.
  • The base object is referenced as OKL_FE_RATE_SET_LEVELS (SYNONYM), meaning the underlying storage resides in the same APPS data model.
  • Because no transformation is applied, the view primarily serves as an abstraction layer for external reads, simplifying access while preserving the base table's native structure and semantics.

No additional joins to rate set headers or version objects are included in the view definition itself; consumers must relate RATE_SET_ID, RATE_SET_VERSION_ID, and RATE_SET_FACTOR_ID to the corresponding parent entities when building full rate set reports.

Key Columns

  • RATE_SET_LEVEL_ID — Unique identifier for the level row; the primary surrogate key for each rate set level.
  • OBJECT_VERSION_NUMBER — Optimistic locking/version column used for concurrency control across EBS objects.
  • RATE_SET_ID — Foreign key to the parent rate set definition.
  • RATE_SET_VERSION_ID — Identifies the specific version of the rate set to which the level belongs.
  • RATE_SET_FACTOR_ID — Reference to the associated rate set factor.
  • SEQUENCE_NUMBER — Ordering value for the level within the rate set.
  • PERIODS — The period count (term tier) applicable to the level.
  • RESIDUAL_PERCENT — Residual value percentage applied at the level.
  • LEASE_RATE_FACTOR — The calculated or defined lease rate factor for the combination of periods and residual percent.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
  • Descriptive flexfields — ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15.

Common Use Cases and Queries

This view is typically consumed by pricing reports, rate set audit extracts, and integration interfaces that need the tier structure of lease rate factors. A common query retrieves all levels for a given rate set and version:

  • SELECT rate_set_level_id, rate_set_id, rate_set_version_id, sequence_number, periods, residual_percent, lease_rate_factor FROM okl_fe_rate_set_levels_v WHERE rate_set_id = :p_rate_set_id AND rate_set_version_id = :p_version_id ORDER BY sequence_number;
  • SELECT rate_set_factor_id, periods, residual_percent, lease_rate_factor FROM okl_fe_rate_set_levels_v WHERE rate_set_factor_id = :p_factor_id ORDER BY periods, residual_percent;

Because the view applies no filtering, standard EBS multi-org and security predicates are not inherent; consumers should constrain by the appropriate ID columns. For date-sensitive extracts, the audit columns support incremental refreshes, while the ATTRIBUTE flexfield columns allow reporting on client-specific extensions configured on the base rate set levels table.