Results for “okl_ext_fa_header_sources_tl”

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

Overview

OKL_EXT_FA_HEADER_SOURCES_TL is a translation (_TL) table in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, owned by the OKL schema. It stores language-specific descriptive attributes for externally sourced fixed asset header extension records, providing multilingual display text for source-driven configuration values used during contract and asset header derivation in the leasing flow. The table complements the base OKL_EXT_FA_HEADER_SOURCES_B entity by holding translated or language-dependent column values keyed by LANGUAGE, a standard EBS MLS (Multi-Language Support) pattern.

From a Data Vault modeling standpoint, the mined relationship structure classifies this object heuristicly as standalone — it holds no outbound foreign keys and functions as an independent language-specific attribute store. In Data Vault terms it behaves as a satellite-like structure attached to a header extension business key, carrying descriptive/filter attributes (contract status, transaction type name) that are time-stamped and audited rather than serving as a pure hub or link.

Key Information Stored

The documented physical schema contains 11 columns. The most significant are:

• HEADER_EXTENSION_ID — Part of the composite primary key and the join anchor back to the header extension entity. This is the business-key component that identifies which header source definition row the translation describes.
• LANGUAGE — The second component of the primary key, identifying the NLS language code (e.g., US, AR, FR) for the row.
• SOURCE_LANG — Indicates the source (base) language of the installed row, used by MLS utilities such as the Translation Synchronization process (FNDLOAD/XML publisher, or the AD/TXE language loaders).
• SFWT_FLAG — The standard EBS "Seed/Force/Whitelist/Translation" flag controlling whether the row is seed data and whether it may be overridden by translations.
• CONTRACT_STATUS — The translated contract status label associated with the header source, used to drive or classify the source record.
• TRANSACTION_TYPE_NAME — The translated transaction type name shown to the user, a core descriptive attribute for reporting and UI display.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns (WHO columns) recording insert and update context.

The surrogate/business identifier is enforced by OKL_EXT_FA_HEADER_SOURCES_T_PK (HEADER_EXTENSION_ID, LANGUAGE), with the unique index OKL_EXT_FA_HEADER_SRCS_TL_U1 (HEADER_EXTENSION_ID, LANGUAGE) serving as the business-key candidate guaranteeing one translation per language per header extension.

Common Use Cases and Queries

This table is typically queried to render language-specific values for header source setup, or to reconcile translation completeness during implementation and upgrades. A representative query joins the base table to retrieve translated names:

• Language-specific lookups: SELECT header_extension_id, transaction_type_name, contract_status FROM okl_ext_fa_header_sources_tl WHERE language = USERENV('LANG');
• Translation gap analysis: compare counts between the base (B) table and the _TL table per HEADER_EXTENSION_ID to identify missing languages.
• Audit reporting: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to track recently changed source descriptions.
• Concurrent program or interface loads that read translated labels before populating asset/contract headers.

Related Objects

• OKL_EXT_FA_HEADER_SOURCES_B — The base entity; join on HEADER_EXTENSION_ID to obtain language-independent columns.
• OKL_EXT_FA_HEADER_SOURCES_VL — The MLS view that unites _B and _TL, providing the primary application-facing access path.
• OKL_EXT_FA_HEADER_SOURCES_T_PK — The composite primary key constraint on (HEADER_EXTENSION_ID, LANGUAGE).
• FND_LANGUAGES — Reference for the LANGUAGE column values.
• FND_LOOKUP_VALUES / FND_LOOKUPS — Frequently joined for source/status code translation validation.
• OKL_EXT_FA_HEADER_SOURCES_TL itself is referenced by MLS translation loader APIs (e.g., FNDLOAD) during patch and upgrade cycles.