Search Results okl_assets_tl




Overview
Explore in AI Chat

Overview

OKL_ASSETS_TL is a translatable (TL) table within the OKL schema, the database owner for Oracle Lease and Finance Management (OKL), an integrated module of Oracle E-Business Suite available in releases 12.1.1 and 12.2.2. The table stores the language-dependent descriptive attributes associated with asset records, and it functions as the translation companion to OKL_ASSETS_B, which holds the language-independent base columns. In Oracle's multi-language architecture, a _B table stores non-translatable columns once per entity, while the corresponding _TL table stores one row per installed language for each translatable attribute. OKL_ASSETS_TL therefore holds the translated short description, description, and comments for each asset, keyed by the asset identifier and the language code.

The ETRM metadata classifies this object heuristically as standalone under the data vault model. This classification reflects the absence of foreign key constraints into other tables within the documented relationship data. Modelers should treat this classification as a suggestion rather than a canonical designation: OKL_ASSETS_TL is functionally a satellite of OKL_ASSETS_B, carrying descriptive, non-key attributes that change independently of the base entity.

Key Information Stored

The table contains twelve documented columns. The most significant include:

  • ID — The asset identifier, forming part of the composite primary key OKL_ASST_PK and joining to the base table OKL_ASSETS_B. This is the true business key inherited from the parent entity.
  • LANGUAGE — The language code (for example, US for American English). Together with ID, it forms the composite primary key and the unique index OKL_ASSETS_TL_U1, ensuring one translation row per asset per language.
  • SOURCE_LANG — Indicates the language from which a translation was derived, supporting Oracle's translation maintenance facilities.
  • SFWT_FLAG — The "seed/flexfield/workflow translation" flag that Oracle's translation infrastructure uses to track whether a row has been synchronized by the translation tools.
  • SHORT_DESCRIPTION — The translated abbreviated asset name or label used in list-of-values windows, flexfields, and lookup displays.
  • DESCRIPTION — The translated full descriptive text for the asset.
  • COMMENTS — The translated free-form comment field for additional asset notes.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle EBS "WHO" audit columns recording row creation and last modification metadata.

The surrogate primary key documented is OKL_ASST_PK (ID, LANGUAGE); the unique index OKL_ASSETS_TL_U1 (ID, LANGUAGE) coincides with it, indicating no separate alternate business key beyond the parent ID and language pairing.

Common Use Cases and Queries

Translations are typically joined back to the base table to produce language-specific asset listings. A representative query retrieves the translated description for a given language while falling back to the base row where no translation exists:

  • SELECT b.id, t.short_description, t.description FROM okl.okl_assets_b b, okl.okl_assets_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
  • Reporting asset inventories by language for multinational lease portfolios, using the LANGUAGE column to filter output.
  • Auditing translation completeness by comparing row counts between OKL_ASSETS_B and OKL_ASSETS_TL grouped by LANGUAGE.
  • Detecting stale translations by comparing LAST_UPDATE_DATE on the TL row against the base row.

Related Objects

  • OKL_ASSETS_B — The base table; joined on ID. It holds the language-independent asset attributes and is the parent entity for this translation row.
  • OKL_ASSETS_V — The commonly used view that merges the _B and _TL tables, presenting translated values for the session language.
  • OKL_ASSETS_TL_U1 — The unique index enforcing one row per ID and LANGUAGE combination.
  • OKL_ASST_PK — The primary key constraint on ID and LANGUAGE.
  • FND_LANGUAGES — The language definition table validating the LANGUAGE column.