Results for “okl_asset_returns_tl”

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

Overview

OKL_ASSET_RETURNS_TL is the translation table for the base table OKL_ASSET_RETURNS_B within the Oracle Leasing and Finance Management (OKL) module. In Oracle EBS Release 12.1.1 and 12.2.2, this table stores the multi-lingual (MLS) translatable columns of asset return records, following Oracle's standard MLS architecture in which language-dependent descriptive attributes are separated from language-independent data. The base table OKL_ASSET_RETURNS_B holds the operational facts of a return, while OKL_ASSET_RETURNS_TL supplies the corresponding user-facing text for each installed language.

The object is owned by the OKL schema and is documented as VALID, with a physical schema of 11 columns in ETRM 12.2.2. The heuristic Data Vault classification, mined from the foreign-key structure, identifies this table as standalone. In a Data Vault modeling suggestion, this would be treated as a satellite-like descriptive structure rather than a hub or link: it carries no independent business key of its own and exists purely to provide language-specific descriptions for its parent entity. The primary key OKL_ASSET_RETURNS_TL_PK is defined on (ID, LANGUAGE), and a unique index OKL_ASSET_RETURNS_TL_U1 also spans (ID, LANGUAGE), confirming the composite nature of the record identity.

Key Information Stored

The table stores eleven documented columns. The most significant are:

• ID — Surrogate identifier inherited from OKL_ASSET_RETURNS_B; part of the composite primary key and the join back to the base table.
• LANGUAGE — The NLS language code for the translated row; the second component of the primary key OKL_ASSET_RETURNS_TL_PK.
• SOURCE_LANG — Indicates the source language of the record, supporting MLS translation workflows.
• SFWT_FLAG — The "Seed/Full/Translation" flag used by Oracle's translation utilities to indicate row status within MLS processing.
• COMMENTS — Free-form translatable text describing the return event.
• NEW_ITEM_DESCRIPTION — Translatable description of the returned or replacement item.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording row creation and modification metadata.

The surrogate primary key is (ID, LANGUAGE). Because ID references the base table and LANGUAGE identifies the locale, the unique index OKL_ASSET_RETURNS_TL_U1 duplicates this combination as a business-key candidate. There is no separate single-column business key in this table; the true business key resides in OKL_ASSET_RETURNS_B.

Common Use Cases and Queries

Typical usage involves joining the translation table to its base table to obtain fully resolved, language-specific asset return detail for reporting or integration. A standard pattern restricts output to the user's session language or the site's base language:

• Reporting asset returns with translated comments for a specific language: SELECT b.id, t.comments, t.new_item_description FROM okl_asset_returns_b b, okl_asset_returns_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
• Auditing translation completeness by counting rows per LANGUAGE against the base table.
• Extracting MLS delta records for data warehouse loads using LAST_UPDATE_DATE and the SFWT_FLAG column to identify untranslated or newly seeded rows.

Because the table is strictly descriptive, it is rarely queried in isolation. It is most commonly consumed through the OKL asset return concurrent programs and the Leasing and Finance Management HTML/forms UI, both of which resolve the base entity and apply the MLS language filter automatically.

Related Objects

The following objects are most significant in relation to OKL_ASSET_RETURNS_TL:

• OKL_ASSET_RETURNS_B — The base table; joined on ID. It supplies the surrogate key and non-translatable attributes.
• OKL_ASSET_RETURNS_VL — The MLS view that unions the base and translation tables to present a single language-resolved row, typically the primary query access path.
• OKL_ASSET_RETURNS_TL_PK / OKL_ASSET_RETURNS_TL_U1 — The primary key constraint and unique index on (ID, LANGUAGE).
• FND_LANGUAGES — Reference for valid LANGUAGE and SOURCE_LANG codes.
• OKL_ASSET_RETURNS_TL dependent Open Interfaces and PL/SQL APIs in the OKL package set, which insert and update translatable rows during return processing.

The table's standalone classification reflects that it depends solely on OKL_ASSET_RETURNS_B through ID and does not participate in further foreign-key relationships within the documented schema.