Search Results okl_ls_rt_fctr_sets_tl




Overview
Explore in AI Chat

Overview

OKL_LS_RT_FCTR_SETS_TL is the translation (MLS) table for the lease rate factor sets entity within the Oracle Lease and Finance Management (OKL) product family. It stores the language-dependent, translatable descriptive columns that accompany the base record held in OKL_LS_RT_FCTR_SETS_B. The table resides in the OKL schema and is marked VALID in the ETRM 12.2.2 documented physical schema. Its purpose is to permit a single logical rate factor set definition to be presented in multiple installed languages, in accordance with Oracle Multi-Lingual Support (MLS) standards, where language-neutral and language-sensitive attributes are separated into a base table and one or more translation rows respectively.

As a heuristic Data Vault classification, this object is best modeled as a satellite, attached to the hub represented by the base table OKL_LS_RT_FCTR_SETS_B. The heuristic relationship data notes the object as "standalone," meaning no foreign key constraints were mined from the FK structure; however, the ID column functionally links each translation row back to the corresponding base record. This classification is a modeling suggestion only and is not an enforced constraint in the ETRM repository.

Key Information Stored

The documented physical schema for OKL_LS_RT_FCTR_SETS_TL contains eleven columns. The surrogate identifier and language discriminator together form the primary key OKL_LRTT_PK (ID, LANGUAGE). The business-key candidate is captured by the unique index OKL_LS_RT_FCTR_SETS_TL_U1, also defined on (ID, LANGUAGE), and reinforced by the second documented unique key OKL_LRTT_UK on NAME.

  • ID — Surrogate identifier inherited from the base table OKL_LS_RT_FCTR_SETS_B; combined with LANGUAGE, it forms the primary key.
  • LANGUAGE — Language code indicating the translation locale for the row; part of the primary key and unique key.
  • SOURCE_LANG — The source language from which the translation was derived, per MLS conventions.
  • SFWT_FLAG — Standard "Seed/Finish/Workflow Translation" flag used by MLS infrastructure to track translation state.
  • NAME — Translatable display name of the rate factor set; a business-key candidate via OKL_LRTT_UK.
  • DESCRIPTION — Free-text descriptive text for the rate factor set in the target language.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns that record row creation and last modification context.

The non-translatable attributes of the rate factor set remain in OKL_LS_RT_FCTR_SETS_B; only the descriptive columns NAME and DESCRIPTION are translated here.

Common Use Cases and Queries

This table is principally accessed to display localized rate factor set names and descriptions on lease and finance management screens, and in reports that must render text in the session language. Queries commonly join the translation table to the base table on ID, filtering on LANGUAGE matched to the user's environment or the base table's language.

  • Retrieve the localized name and description for a specific rate factor set:
    SELECT t.name, t.description FROM okl.okl_ls_rt_fctr_sets_tl t WHERE t.id = :p_id AND t.language = USERENV('LANG');
  • List all translations available for a set, useful for multi-language maintenance and audit:
    SELECT t.language, t.name, t.description FROM okl.okl_ls_rt_fctr_sets_tl t WHERE t.id = :p_id;
  • Fallback query where no translation exists in the session language, returning the base-language row: join OKL_LS_RT_FCTR_SETS_B and select the translation matching the base LANGUAGE, otherwise the base columns.

Reporting scenarios include translation completeness checks (comparing the count of translation rows against the base table row count, grouped by LANGUAGE) and change tracking via LAST_UPDATE_DATE for localization governance.

Related Objects

  • OKL_LS_RT_FCTR_SETS_B — The base (language-neutral) table supplying the ID and other non-translatable attributes; joined on ID with LANGUAGE filtering.
  • OKL_LS_RT_FCTR_SETS_B.NAME / DESCRIPTION — The source columns whose translated equivalents are stored here, per the ETRM description.
  • FND_LANGUAGES — Reference table for valid LANGUAGE and SOURCE_LANG codes used in translations.
  • OKL_LS_RT_FCTRS — Rate factor records related to the factor set definitions; typically referenced through the base table's ID.
  • FND_LOOKUPS / FND_TERRITORIES — Standard MLS and locale reference objects used alongside language resolution.
  • OKL rate factor setup and maintenance APIs/forms — The functional entry points that insert and update rows in this translation table through the base-table DML flow.