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:
- RATE_SET_LEVEL_ID — surrogate primary key and the sole business-key candidate per the documented unique index; it uniquely identifies each rate set level row.
- RATE_SET_ID — identifies the parent rate set with which the level is associated.
- RATE_SET_VERSION_ID — foreign key to OKL_FE_RATE_SET_VERSIONS, tying the level to a specific versioned rate set.
- RATE_SET_FACTOR_ID — foreign key to OKL_LS_RT_FCTR_ENTS, linking the level to the source rate factor entity.
- SEQUENCE_NUMBER — orders the level within the rate set, defining tier or step order.
- PERIODS — the period count or range to which the level applies.
- RESIDUAL_PERCENT — the residual value percentage used in the rate factor calculation.
- LEASE_RATE_FACTOR — the actual lease rate factor computed or assigned for this level.
- OBJECT_VERSION_NUMBER — optimistic locking column used to detect concurrent updates.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking row creation and modification.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) columns for customer-extensible data.
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.
-
Lease Rate Factor Levels
-
Lease Rate Factor Levels
-
Lease Rate Factor Levels View
APPS.OKL_FE_RATE_SET_LEVELS_V·↳ OKL_FE_RATE_SET_LEVELS·Explore OKL module →
-
Lease Rate Factor Levels View
APPS.OKL_FE_RATE_SET_LEVELS_V·↳ OKL_FE_RATE_SET_LEVELS·Explore OKL module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
Foreign Keys 12.2.2
-
Foreign Keys 12.1.1