Search Results okl_ls_rt_fctr_ents_pk




Overview
Explore in AI Chat

Overview

The table OKL_LS_RT_FCTR_ENTS is a core data object within the Oracle E-Business Suite (EBS) module OKL (Lease and Finance Management). It functions as a child table to OKL_LS_RT_FCTR_SETS_B. Its primary role is to store the specific financial factor entries that define the terms of a lease or finance agreement. These entries are critical for calculating lease rates, payments, and other financial metrics. The table is essential for the configuration and execution of complex lease pricing models, enabling the system to associate specific interest rates, residual values, and terms with unique rate factor sets and their versions.

Key Information Stored

The table stores discrete financial parameters linked to a rate factor set. Key columns include the primary key ID, and the unique key combination of LRT_ID, TERM_IN_MONTHS, RESIDUAL_VALUE_PERCENT, and INTEREST_RATE. This structure allows for the precise definition of a rate based on a specific lease term and residual value percentage. The LRT_ID links the entry to its parent rate factor set in OKL_LS_RT_FCTR_SETS_B. The RATE_SET_VERSION_ID and RATE_SET_FACTOR_ID are foreign keys that integrate this table with the broader rate management framework (OKL_FE_RATE_SET_VERSIONS and OKL_FE_RATE_SET_LEVELS), ensuring data integrity and version control for pricing models.

Common Use Cases and Queries

This table is central to lease pricing and quotation generation. A common use case is retrieving the applicable interest rate for a lease proposal given a specific term and target residual value. System processes and custom reports query this table to support rate lookups and audit pricing configurations. A typical SQL pattern involves joining to the parent set table to get a complete rate card.

  • Rate Lookup: SELECT interest_rate FROM okl_ls_rt_fctr_ents WHERE lrt_id = :p_lrt_id AND term_in_months = :p_term AND residual_value_percent = :p_residual;
  • Audit Report: Queries joining OKL_LS_RT_FCTR_SETS_B to OKL_LS_RT_FCTR_ENTS to list all configured rate factors for a given product or lessor.

Related Objects

OKL_LS_RT_FCTR_ENTS is a nexus within the Lease Management schema, with defined relationships to several key tables.

  • Parent Table: OKL_LS_RT_FCTR_SETS_B (via foreign key on LRT_ID).
  • Foreign Key References: OKL_FE_RATE_SET_VERSIONS (via RATE_SET_VERSION_ID) and OKL_FE_RATE_SET_LEVELS (via RATE_SET_FACTOR_ID).
  • Indexes/Keys: Relies on OKL_LS_RT_FCTR_ENTS_PK (ID) and OKL_LS_RT_FCTR_ENTS_UK (LRT_ID, TERM_IN_MONTHS, RESIDUAL_VALUE_PERCENT, INTEREST_RATE) for data integrity and performance.