Search Results okl_ls_rt_ftr_sets_all_b




Overview
Explore in AI Chat

Overview

The table OKL_LS_RT_FTR_SETS_ALL_B is the Rate Card (Lease Rate Set) header table within Oracle E-Business Suite's Leasing and Finance Management (OKL) module. It serves as the foundational master record for lease rate configuration, defining the header-level attributes of a rate set that drives pricing, interest calculation, and factor derivation across lease and finance transactions. In ETRM 12.2.2 the table resides in the OKL schema and is documented with a status of VALID, comprising 37 columns and supporting multi-organization deployment through the ORG_ID column.

From a heuristic Data Vault modeling perspective, the FK analysis classifies this object as standalone, suggesting it functions as a hub-like entity within the rate configuration domain. Unlike link or satellite constructs that depend on parent entities, this table anchors its own identity through the ID surrogate key, with downstream configuration tables referencing it rather than the reverse. This classification should be treated as a modeling suggestion rather than a physical constraint.

Key Information Stored

The table's primary structural elements and their roles are as follows:

Common Use Cases and Queries

Typical reporting and integration scenarios center on rate lookup and effective-dated pricing analysis. A standard identifier query would be:

  • SELECT id, name, rate, currency_code, sts_code FROM okl_ls_rt_ftr_sets_all_b WHERE org_id = :p_org_id AND sts_code = 'ACTIVE';
  • Rate card resolution by date uses START_DATE and END_DATE against the transaction date to determine the governing rate.
  • Frequency and arrears filtering supports periodic billing and interest accrual reconciliation reports.
  • DFF attribute retrieval supports client-specific extensions via ATTRIBUTE_CATEGORY.

These queries are common in lease pricing validation, integration with external rating engines, and audit reporting that requires reconstructing the rate in force at contract inception.

Related Objects

  • OKL_FE_EO_TERMS_ALL_B — Joined via END_OF_TERM_ID to resolve end-of-term options.
  • OKL_LS_RT_FCTR_SETS — The factor (detail) set table linked by the rate set header, holding derived factors.
  • OKL_LS_RT_SETS_TL — Translation table typically paired with _B for multilingual name descriptions.
  • OKL_TXL_CNTRCTS_ALL_B — Lease contracts referencing the rate set during pricing.
  • OKL_FE_PRODUCTS_ALL_B — Product definitions referenced through PDT_ID.
  • OKL_FE_TERMS_ALL_B — Term structures referenced through TRY_ID.