Results for “okl_ls_rt_fctr_ents”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_LS_RT_FCTR_ENTS is a child table within the OKL (Lease and Finance Management) schema in Oracle EBS 12.1.1 and 12.2.2. It stores the individual entry rows that belong to a lease rate factor set header defined in OKL_LS_RT_FCTR_SETS_B. Each row represents a distinct combination of lease term, residual value percentage, interest rate, and derived lease rate factor, forming the granular data that drives lease pricing and rate calculation logic in the Lease and Finance Management module.

From a Data Vault modeling perspective, this object is heuristically classified as satellite-leaning. It carries descriptive, time-bound measurement attributes (term, residual percentage, interest rate, lease rate factor) linked back to a parent entity, which is characteristic of satellite behavior rather than a hub or link structure. This classification is a modeling suggestion only and does not reflect a physically implemented Data Vault design in EBS.

Key Information Stored

The primary surrogate key is ID, enforced by the primary key constraint OKL_LS_RT_FCTR_ENTS_PK and backed by the unique index OKL_LS_RT_FCTR_ENTS_U1. A documented business-key candidate, OKL_LS_RT_FCTR_ENTS_UK, is defined over LRT_ID, TERM_IN_MONTHS, RESIDUAL_VALUE_PERCENT, and INTEREST_RATE, ensuring no duplicate rate combinations exist within a factor set.

• ID — Surrogate primary key uniquely identifying each entry row.
• LRT_ID — Foreign key linking the entry to its parent rate factor set header.
• TERM_IN_MONTHS — Lease term duration expressed in months; part of the business key.
• RESIDUAL_VALUE_PERCENT — Residual value expressed as a percentage; part of the business key.
• INTEREST_RATE — Applicable interest rate for the entry; part of the business key.
• LEASE_RATE_FACTOR — The computed rate factor used in lease payment calculations.
• RATE_SET_VERSION_ID — Foreign key to OKL_FE_RATE_SET_VERSIONS, tying the entry to a specific rate set version.
• OBJECT_VERSION_NUMBER — Optimistic locking column supporting concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit trail columns.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — DFF (descriptive flexfield) columns for customer-defined extensions.

Common Use Cases and Queries

This table is primarily queried during lease rate factor derivation and pricing validation. A frequent pattern retrieves all entries for a specific rate factor set:

• SELECT term_in_months, residual_value_percent, interest_rate, lease_rate_factor FROM okl_ls_rt_fctr_ents WHERE lrt_id = :lrt_id ORDER BY term_in_months, residual_value_percent, interest_rate;
• Joining to the parent header to obtain context for reporting: SELECT b.set_name, e.* FROM okl_ls_rt_fctr_ents e, okl_ls_rt_fctr_sets_b b WHERE e.lrt_id = b.lrt_id;
• Resolving the rate set version lineage by joining RATE_SET_VERSION_ID to OKL_FE_RATE_SET_VERSIONS for audit and historical rate analysis.
• Reverse lookups from OKL_FE_RATE_SET_LEVELS via RATE_SET_FACTOR_ID to identify which levels consume a given factor entry.

Reporting scenarios include rate sheet generation, residual and interest sensitivity analysis, and reconciliation between pricing versions.

Related Objects

• OKL_LS_RT_FCTR_SETS_B — Parent header table; joined on LRT_ID.
• OKL_FE_RATE_SET_VERSIONS — Referenced via RATE_SET_VERSION_ID for version lineage.
• OKL_FE_RATE_SET_LEVELS — Child table referencing this table through RATE_SET_FACTOR_ID.

These three foreign key relationships define the object's position within the lease rate factor hierarchy and support both upward header resolution and downward level consumption.