Search Results okl_ls_rt_fctr_sets_b




Overview
Explore in AI Chat

Overview

The OKL_LS_RT_FCTR_SETS_B table is a core data structure within the Oracle E-Business Suite (EBS) module for Lease and Finance Management (OKL). It functions as the header or master table for Rate Cards, which are also referred to as Lease Rate Sets. In the context of lease and finance operations, a Rate Card is a critical business object that defines the pricing rules, interest rates, and other financial factors applicable to lease products and contracts. This table stores the foundational metadata for each unique Rate Card, enabling the system to associate specific pricing logic with lease transactions and product offerings. Its role is central to the configuration and execution of lease pricing within the application.

Key Information Stored

As a header table, OKL_LS_RT_FCTR_SETS_B holds the defining attributes for a Rate Card set. The primary key is the ID column, which uniquely identifies each rate set record. Critical foreign key relationships define its integration with other master data. The PDT_ID column links the rate set to a specific lease product defined in the OKL_PRODUCTS table, establishing which product the pricing rules govern. The TRY_ID column links to a transaction type in OKL_TRX_TYPES_B, defining the business context (e.g., lease booking, amendment) for which the rate set is valid. A significant recursive relationship is managed through the ORIG_RATE_SET_ID column, which can point to another record within the same table, allowing for the versioning or derivation of rate sets from an original template.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and inquiry of lease pricing structures. Common operational scenarios include the creation of new rate cards for product launches, modification of existing rates for market adjustments, and auditing rate history. A typical query would join this header table to its associated line detail tables (not listed in the provided metadata but commonly named with a _TL suffix or as child tables like OKL_LS_RT_FCTRS_B) to retrieve a complete rate card definition for a given product. For reporting, analysts might query this table to list all active rate sets, their associated products, and effective dates. A sample SQL pattern to find rate sets for a specific product would be:

  • SELECT rfs.ID, rfs.NAME, prod.PRODUCT_NAME FROM OKL_LS_RT_FCTR_SETS_B rfs JOIN OKL_PRODUCTS prod ON rfs.PDT_ID = prod.ID WHERE prod.PRODUCT_CODE = '<PRODUCT_CODE>';

Related Objects

The OKL_LS_RT_FCTR_SETS_B table is a nexus for lease pricing data, with several key dependencies as indicated by its foreign keys. Its primary relationships are with the OKL_PRODUCTS table, which defines lease products, and the OKL_TRX_TYPES_B table, which defines transaction types. The recursive foreign key on ORIG_RATE_SET_ID creates a relationship within the table itself for tracking rate set lineage. This header table will have one or more child tables storing the detailed rate factors (e.g., interest rates, payment frequencies) that comprise the complete rate card. Furthermore, it is referenced by the lease contract headers or lines (typically in tables like OKL_K_HEADERS_B) to apply the correct pricing rules to a specific lease agreement.