Results for “okl_asset_pools_tl”

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

Overview

OKL_ASSET_POOLS_TL is the translation (language) table for the base table OKL_ASSET_POOLS within the Oracle E-Business Suite Release 12.1.1 / 12.2.2 Leasing and Finance Management (OKL) module. Its purpose is to store language-specific, user-facing descriptive text — primarily names and descriptions of asset pools — keyed by the base entity identifier and a language code, thereby enabling multi-language support for asset pooling functionality used in lease and finance contracts.

The ETRM metadata classifies this object, using a heuristic derived from its foreign-key structure, as standalone with respect to a Data Vault model. In practice this classification suggests the table should be modeled as a satellite-like object holding descriptive, language-dependent attributes of the asset pool hub (OKL_ASSET_POOLS), rather than as an independent hub or link. Note that the documentation explicitly indicates this table is not implemented in the reference database, so its presence and content depend on whether the corresponding language or multi-lingual feature is configured in a given environment.

Key Information Stored

The table follows Oracle's standard translation-table pattern for the Applications (non-MultiLingual Support alias) localization framework. The most significant columns are:

• ID — Surrogate identifier of the asset pool. This is the foreign-key column that joins back to the primary key of OKL_ASSET_POOLS. It is part of the composite primary key.
• LANGUAGE — The language code (for example, US, DE, FR) that identifies the localization of the descriptive row. It is the second component of the composite primary key.
• NAME / DESCRIPTION (business-key and descriptive columns) — The translated, user-visible name and description of the asset pool, which are the attributes that differ per language and are presented in the OKL user interface and reports.
• SOURCE_LANG — The language in which the base (source) record was originally entered, used by the translation framework to determine whether a translated row is required.

The composite primary key is documented as OKL_ASSET_POOLS_TL_PK (ID, LANGUAGE). Correspondingly, the surrogate primary key of the row is the pairing of ID and LANGUAGE; ID alone is a business-key candidate that links to the base pool definition, while LANGUAGE discriminates the translated instance. Structural columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN are expected in accordance with the EBS WHO-column convention, though they are not itemized in the supplied metadata excerpt.

Common Use Cases and Queries

Translation tables are consumed primarily for display. Reporting against OKL_ASSET_POOLS_TL is typically performed to resolve the correct language-specific name of an asset pool for a given session or user locale. Typical join patterns restrict output to the language of interest:

• Joining OKL_ASSET_POOLS to OKL_ASSET_POOLS_TL on P.ID = TL.ID and TL.LANGUAGE = USERENV('LANG') to produce localized pool names.
• Extracting the full translation set for a pool (WHERE TL.ID = :pool_id) to audit or populate multilingual interfaces.
• Using NVL or a fallback pattern to default to SOURCE_LANG when no translation exists for the requested language.

Because the object is documented as not implemented in the reference database, any query should be preceded by a data-dictionary check (for example, via ALL_TAB_COLUMNS) to confirm existence before runtime use.

Related Objects

The most significant related objects, based on the documented primary-key relationship and the standard translation framework, are:

• OKL_ASSET_POOLS — The base table; joined on OKL_ASSET_POOLS.ID = OKL_ASSET_POOLS_TL.ID.
• OKL_ASSET_POOLS_B (where the base entity is split into _B/_TL) — the business/definition table underlying the translated descriptions.
• FND_LANGUAGES — Provides valid LANGUAGE codes referenced by the LANGUAGE column.
• OKL_ASSET_POOLS_TL_PK — The primary-key constraint enforcing uniqueness of (ID, LANGUAGE).
• OKL lease and finance contract tables that indirectly reference asset pools through OKL_ASSET_POOLS for reporting and pool assignment.

These relationships reflect the ETRM-documented key structure and the conventional Oracle translation architecture for Release 12.1.1 and 12.2.2.