Search Results okl_fe_rate_set_levels

Overview

The OKL_FE_RATE_SET_LEVELS table is a core data object within the Oracle E-Business Suite (EBS) module for Leasing and Finance Management (OKL). It functions as the master repository for lease rate factor levels. In the context of lease pricing and structuring, a rate set defines a collection of factors used to calculate lease payments. This table stores the individual levels or tiers within a given rate set, enabling the configuration of complex, multi-tiered pricing models. Its role is critical for the financial engine, as it directly supports the calculation of rates, payments, and revenue recognition for lease contracts in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to define the hierarchy and parameters of rate levels. Key columns, as indicated by its primary and foreign keys, include RATE_SET_LEVEL_ID (the unique identifier), RATE_SET_ID (linking to the parent rate set definition), RATE_SET_VERSION_ID (linking to a specific version of that rate set for effective dating and audit control), and RATE_SET_FACTOR_ID (linking to the specific lease rate factor entity that contains the actual calculation logic or value). This structure allows a single rate set version to contain multiple levels, each potentially associated with a different factor, facilitating granular pricing rules based on asset type, customer tier, or other business criteria.

Common Use Cases and Queries

This table is central to lease product setup and financial inquiry. A common use case is analyzing the pricing structure of a specific lease product. For instance, a business analyst might query all rate levels for an active rate set to validate tiered pricing logic. A typical reporting query would join this table to its related entities to extract a comprehensible rate schedule.

• Sample Query: To list all levels for a specific rate set, one might use: SELECT level.rate_set_level_id, factor.factor_name, level.rate_set_version_id FROM okl_fe_rate_set_levels level, okl_ls_rt_fctr_ents factor WHERE level.rate_set_factor_id = factor.rate_set_factor_id AND level.rate_set_id = :p_rate_set_id ORDER BY level.rate_set_level_id;
• Another critical use case is during the lease booking process, where the application logic references this table to determine the correct rate factor to apply based on the contract's attributes, impacting the calculation of the lease stream.

Related Objects

As defined by its foreign key constraints, OKL_FE_RATE_SET_LEVELS has integral relationships with several other key tables in the Leasing module.

• OKL_FE_RATE_SET_VERSIONS: This relationship (via RATE_SET_VERSION_ID) ties a rate level to a specific, effective-dated version of a rate set, ensuring historical accuracy and auditability.
• OKL_LS_RT_FCTR_ENTS: The link via RATE_SET_FACTOR_ID connects the level to the concrete mathematical factor or value (e.g., a specific interest rate or depreciation method) stored in this entity.
• The self-referencing foreign key on RATE_SET_ID indicates a direct relationship to the master rate set definition, which is likely stored in a parent table such as OKL_FE_RATE_SETS_B.
• Consequently, this table is a fundamental junction in the data model, sitting between rate set definitions, their versions, and the executable pricing factors.