Results for “okl_txd_assets_tl”

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

Overview

OKL_TXD_ASSETS_TL is a translatable (MLS) child table in the OKL schema of Oracle E-Business Suite, belonging to the Lease and Finance Management (OKL) product family. Per Multi-Lingual Support (MLS) standards, it stores the language-dependent descriptive columns that belong to records whose language-independent attributes reside in OKL_TXD_ASSETS_B. Each row pairs a base record identity with an installed Oracle language code, so a single asset/tax-attribute definition can carry a distinct description in every deployed language.

The table is classified VALID in the ETRM 12.2.2 documentation and its documented physical schema contains 10 columns. Under a heuristic Data Vault classification, the structure resolves as a standalone object: it carries no foreign-key relationships in the mined relationship data, so rather than acting as a hub, link, or satellite within a modelled integration vault, it is best treated as a reference/translation artifact. Practical Data Vault designs therefore typically model it as a language satellite attached to whatever hub represents the base OKL_TXD_ASSETS_B entity.

Key Information Stored

The table's identity is defined by the primary key OKL_TXD_ASSETS_TL_PK, composed of ID and LANGUAGE. A unique index, OKL_TXD_ASSETS_TL_U1, repeats the same (ID, LANGUAGE) business key, guaranteeing one translation row per asset record per language. The most significant columns are:

• ID — Surrogate identifier inherited from the base table; the join key to OKL_TXD_ASSETS_B.
• LANGUAGE — Oracle language code (for example US, DE, JA) qualifying the translated row; part of both the PK and the unique index.
• SOURCE_LANG — The language from which the translation was derived, supporting MLS source-tracking.
• SFWT_FLAG — The "Seed From Web Translation" indicator, marking rows whose text originated from a translation seed rather than direct user entry.
• DESCRIPTION — The translated, user-facing description of the asset or tax-attribute definition; the principal payload of the table.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last maintained a translation, when, and through which login session.

Common Use Cases and Queries

The dominant use case is retrieving a single-language description for the base asset definition without scanning every installed language. A typical query joins to the base table and filters by language and, where required, by the MLS source columns:

SELECT t.description, t.source_lang
FROM okl.okl_txd_assets_tl t
WHERE t.id = :asset_id AND t.language = USERENV('LANG');

Reporting use cases include multi-language listings that pivot DESCRIPTON across languages, translation-completeness audits that detect base records lacking a row in a required language, and seed-tracking reports that isolate rows where SFWT_FLAG indicates seeded text. Auditors also query the LAST_UPDATED_BY and LAST_UPDATE_DATE columns to determine when a translated description last changed and by whom.

Related Objects

• OKL_TXD_ASSETS_B — The language-independent parent; joined on ID (base), the source of every translated row.
• OKL_TXD_ASSETS_TL_PK / OKL_TXD_ASSETS_TL_U1 — The primary-key constraint and unique index enforcing the (ID, LANGUAGE) business key.
• FND_LANGUAGES — Reference view supplying the installed language codes used in LANGUAGE and SOURCE_LANG.
• FND_TERRITORIES — Companion reference used when language selections are resolved through territory configuration.
• OKL_TXD_ASSETS_VL — The MLS view that unions the base and translation tables for simplified single-row access.
• OKL_TXD_ASSETS_TL table-level APIs — MLS insert/update routines used by the OKL transaction design tooling to maintain translated descriptions.