Search Results okl_ls_rt_fctr_sets_tl_u1

Overview

OKL.OKL_LS_RT_FCTR_SETS_TL is the translation (TL) table for the Lease Rate Factor Sets entity within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It stores language-specific, translated content for the base table OKL_LS_RT_FCTR_SETS_B, following Oracle's Multi-Lingual Support (MLS) architecture. In EBS 12.1.1 and 12.2.2, each translatable row in the base table is represented here once per installed language, allowing the same logical rate factor set to present localized names and descriptions to users depending on their session language.

The object is classified as VALID in the ETRM metadata and resides in the APPS_TS_TX_DATA tablespace with PCT Free 10. Under a heuristic Data Vault classification, this table suggests a satellite pattern, since it carries descriptive, language-dependent attributes (NAME, DESCRIPTION) keyed to the parent entity rather than acting as a hub or a link. The primary key is documented as OKL_LRTT_PK on the (ID, LANGUAGE) column pair.

Key Information Stored

The table holds eleven documented columns. The most significant for querying and reporting are:

• ID — Surrogate primary key column. It is also the foreign reference back to the base table OKL_LS_RT_FCTR_SETS_B, tying each translated row to its master entity.
• LANGUAGE — The language code for which the NAME and DESCRIPTION values are supplied.
• SOURCE_LANG — The source language from which the translation was derived, used by the MLS translation process.
• SFWT_FLAG — A column consumed by the translation batch program to manage the synchronization of translated rows.
• NAME — Column marked "No Longer Used" in the documented metadata; retained for historical compatibility but not actively populated.
• DESCRIPTION — The user-entered description of the Lease Rate Set, defined at length 1995 and the principal translatable business attribute.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns providing audit trail information for each translated row.

The business-key candidate recorded in the metadata is the unique index OKL_LS_RT_FCTR_SETS_TL_U1, defined on (ID, LANGUAGE). This mirrors the primary key and confirms that a given entity may have only one translated row per language.

Common Use Cases and Queries

Typical scenarios center on multilingual reporting and localized display of lease rate factor sets. Reports that must present the rate set description in the user's session language join the translation table to the base table. A representative query pattern retrieves the description for a specific language:

• SELECT t.ID, t.LANGUAGE, t.DESCRIPTION FROM OKL.OKL_LS_RT_FCTR_SETS_TL t WHERE t.LANGUAGE = USERENV('LANG');
• Joining to the base table: SELECT b.ID, t.DESCRIPTION FROM OKL_OKL_LS_RT_FCTR_SETS_B b, OKL.OKL_LS_RT_FCTR_SETS_TL t WHERE b.ID = t.ID AND t.LANGUAGE = USERENV('LANG');
• Auditing translation coverage: SELECT ID, LANGUAGE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM OKL.OKL_LS_RT_FCTR_SETS_TL ORDER BY ID, LANGUAGE;

Administrators may also use the table to verify which languages have been translated for a given rate factor set and to inspect when translations were last refreshed.

Related Objects

The most significant related objects are those in the base/translation pair and the surrounding rate factor framework:

• OKL.OKL_LS_RT_FCTR_SETS_B — The base table holding language-independent columns; joined on ID.
• APPS.OKL_LS_RT_FCTR_SETS_TL — The synonym or view exposing this table to the APPS schema.
• OKL_LRTT_PK — The primary key constraint enforcing uniqueness of (ID, LANGUAGE).
• OKL_LS_RT_FCTR_SETS_TL_U1 — The unique index on (ID, LANGUAGE) noted in the query metadata.
• Lease rate factor set maintenance forms and the MLS translation batch programs that populate SFWT_FLAG and translated rows.

The ETRM metadata notes that this table does not reference any other database object directly, and its principal documented dependency is the APPS synonym. The final two footer lines attribute the content to Oracle Proprietary, Confidential Information.