Results for “okl_fe_rate_set_levels”

50+ results




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

Overview

OKL_FE_RATE_SET_LEVELS is a transactional detail table within the Oracle Leasing and Finance Management (OKL) module, storing individual rate factor levels that belong to a lease rate set. In Oracle E-Business Suite 12.1.1 and 12.2.2, this table captures tiered or stepped rate factor definitions — for example, residual percentages and lease rate factors applied across defined period ranges — that together make up a complete rate set version used by the Lease and Finance Management pricing engine.

The table is owned by the OKL schema and is documented as VALID with 30 columns. Its primary key, OKL_FE_RATE_SET_LEVELS_PK, is defined on RATE_SET_LEVEL_ID, and a unique index, OKL_FE_RATE_SET_LEVELS_U1, is also defined on the same column. Based on the foreign key structure supplied in the metadata, the heuristic Data Vault classification for this object is link. This suggests it functions as an associative entity joining a rate set version, a rate set factor entity, and a rate set identifier, rather than acting as an independent hub.

Key Information Stored

The most significant columns in OKL_FE_RATE_SET_LEVELS are:

The surrogate PK (RATE_SET_LEVEL_ID) should be distinguished from the parent references (RATE_SET_ID, RATE_SET_VERSION_ID, RATE_SET_FACTOR_ID), which supply the business relationships rather than row identity.

Common Use Cases and Queries

Typical scenarios include pricing diagnostics, rate set maintenance, and reporting on lease rate factor tiers. A common query retrieves all levels for a given rate set version, ordered by sequence:

  • SELECT rate_set_level_id, sequence_number, periods, residual_percent, lease_rate_factor FROM okl_fe_rate_set_levels WHERE rate_set_version_id = :version_id ORDER BY sequence_number;
  • Joining to the version table to confirm the active rate set: SELECT l.* FROM okl_fe_rate_set_levels l, okl_fe_rate_set_versions v WHERE l.rate_set_version_id = v.rate_set_version_id AND v.rate_set_id = :rate_set_id;
  • Reconciling levels to their source rate factor entities through OKL_LS_RT_FCTR_ENTS via RATE_SET_FACTOR_ID.

These queries support amortization verification, residual value validation, and audit of rate factor changes across versions.

Related Objects

The following objects are most significant in relation to OKL_FE_RATE_SET_LEVELS, based on documented FK relationships:

  • OKL_FE_RATE_SET_VERSIONS — parent version table joined on RATE_SET_VERSION_ID.
  • OKL_LS_RT_FCTR_ENTS — rate factor entity table joined on RATE_SET_FACTOR_ID.
  • OKL_FE_RATE_SET_LEVELS — self-referencing relationship for RATE_SET_ID and RATE_SET_FACTOR_ID.
  • The rate set master and related pricing engine tables that consume RATE_SET_ID within the OKL leasing pricing configuration.
  • Lease rate factor and residual value reporting views built over this pricing data.

Together, these objects form the rate set configuration hierarchy used by Oracle Leasing and Finance Management pricing and contract generation.