Results for “okl_xtl_pay_invs_tl”

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

Overview

OKL_XTL_PAY_INVS_TL is a translation (MLS) table in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 Leasing and Finance Management (OKL) module. It stores the language-dependent, translatable columns associated with the base table OKL_XTL_PAY_INVS_B, following Oracle's Multi-Lingual Support (MLS) standards. In Oracle EBS, MLS tables allow descriptive attributes such as names and descriptions to be captured in multiple installed languages while the structural, non-translatable data resides in the corresponding base ("_B") table. This table is owned by the OKL schema and its status is VALID.

From a Data Vault modeling perspective, the ETRM metadata classifies this object heuristically as standalone. It is best treated as a satellite-like attribute table: it holds descriptive, in this case translatable, context around a business entity rather than acting as a hub (which would store unique business keys) or a link (which would resolve relationships between hubs). The absence of foreign key relationships reinforces its role as an independent descriptive store.

Key Information Stored

The documented physical schema contains 11 columns. The most significant are summarized below, distinguishing surrogate identity from business-key candidates.

• ID — Part of the composite primary key (OKL_XTL_PAY_INVS_TL_PK) and part of the unique index OKL_XTL_PAY_INVS_TL_U1. This is the surrogate identifier linking the translated row back to its parent record in OKL_XTL_PAY_INVS_B.
• LANGUAGE — The other half of the composite primary key and of unique index U1. Stores the NLS language code identifying which translation the row carries.
• SOURCE_LANG — Indicates the source (base) language from which the translation was derived, per MLS convention.
• SFWT_FLAG — The standard Oracle MLS "Seed/Foreign/Whichever Translated" flag governing which row is returned when a translation is missing.
• DESCRIPTION — The primary translatable descriptive attribute, holding the user-facing text for the payables invoice record in the selected language.
• STREAM_TYPE — A translatable classification attribute describing the stream type associated with the payables invoice.
• CREATED_BY, CREATION_DATE — Standard audit columns capturing who created the row and when.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification and its originating session.

The unique index OKL_XTL_PAY_INVS_TL_U1 on (ID, LANGUAGE) represents the true business-key candidate, guaranteeing one translation row per entity per language, while the PK enforces the same combination as the physical identity.

Common Use Cases and Queries

This table is queried whenever translated descriptive text must be presented for OKL payables invoice records, typically through the MLS framework rather than direct access. Common scenarios include multi-language reporting, localized user interfaces, and reconciliation of translation completeness.

A typical join resolves base and translation rows:

• SELECT b.id, t.description, t.stream_type FROM okl_xtl_pay_invs_b b, okl_xtl_pay_invs_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');

Reporting use cases include auditing which languages have translations, identifying missing translations via SFWT_FLAG, and extracting localized descriptions for downstream reporting extracts. Filtering by LANGUAGE is essential because the table can hold many languages per ID.

Related Objects

The most significant related objects, based on the documented schema and MLS standards, include:

• OKL_XTL_PAY_INVS_B — The base table; joined on ID, supplying the non-translatable columns.
• OKL_XTL_PAY_INVS_TL_PK — The composite primary key (ID, LANGUAGE) enforcing row identity.
• OKL_XTL_PAY_INVS_TL_U1 — The unique index (ID, LANGUAGE) supporting business-key lookups and the MLS join.
• FND_LANGUAGES — The language reference table validating LANGUAGE and SOURCE_LANG values.
• FND_SESSIONS / USERENV('LANG') — Provides the runtime language for standard MLS queries.
• Related OKL payables invoice views and concurrent extract programs that surface translated DESCRIPTION and STREAM_TYPE.