Results for “okl_ext_ap_header_sources_tl”

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

Overview

OKL_EXT_AP_HEADER_SOURCES_TL is a translation table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores language-specific, translated values for the descriptive attributes associated with external accounts payable header sources used by the leasing application. In the context of Oracle EBS, the "_TL" suffix designates a translation table, meaning one logical parent row in the corresponding base table can have multiple rows here — one per installed language. The table enables multilingual presentation of the contract status, agreement status, and transaction type text that appears on lease-related AP header source definitions.

From a Data Vault modeling perspective, the mined FK structure classifies this object as standalone, which is best read as a modeling suggestion rather than a documented constraint. In practice, the presence of a LANGUAGE column and a composite primary key suggests the table behaves as a satellite carrying descriptive, language-dependent attributes keyed to a parent extension identifier. Because the metadata exposes no foreign key relationships to other tables, any linkage to a base entity is referential by convention rather than enforced by the database.

Key Information Stored

The table contains twelve documented columns. The most significant are listed below; surrogate and business keys are distinguished where the metadata supports it.

• HEADER_EXTENSION_ID — the identifier linking each translated row to its parent extension record; part of the primary key.
• LANGUAGE — the installed language code for the translated text; the second component of the primary key.
• SOURCE_LANG — indicates the source language from which the translation was derived, supporting the standard EBS translation pattern.
• SFWT_FLAG — the standard EBS "Seed/Force/Whatever" translation flag governing whether the row is a seed translation and how it is maintained during upgrades.
• CONTRACT_STATUS — the translated contract status value.
• INV_AGRMNT_STATUS — the translated investment agreement status value.
• TRANSACTION_TYPE_NAME — the translated transaction type name.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS who-column audit attributes covering creation and last modification.

The surrogate primary key is OKL_EXT_AP_HEADER_SOURCES_TL_P, defined on (HEADER_EXTENSION_ID, LANGUAGE). A unique index, OKL_EXT_AP_HEADER_SRCS_TL_U1, exists on the same column pair, confirming that the combination of extension identifier and language is the business-key candidate that guarantees one translated row per language per parent.

Common Use Cases and Queries

Typical usage centers on reporting and validation of multilingual header source definitions. A common pattern joins the translation table to the parent and filters by the session or reporting language.

• Retrieving translated statuses for a specific extension in a given language: SELECT CONTRACT_STATUS, INV_AGRMNT_STATUS, TRANSACTION_TYPE_NAME FROM OKL_EXT_AP_HEADER_SOURCES_TL WHERE HEADER_EXTENSION_ID = :id AND LANGUAGE = USERENV('LANG');
• Auditing multilingual coverage, checking which extensions lack a translation for a target language: SELECT HEADER_EXTENSION_ID FROM OKL_EXT_AP_HEADER_SOURCES_TL WHERE LANGUAGE = 'US' MINUS SELECT HEADER_EXTENSION_ID FROM OKL_EXT_AP_HEADER_SOURCES_TL WHERE LANGUAGE = 'FR';
• Backing a value set or LOV that must present contract and agreement statuses in the user's language.
• Seed-translation maintenance, filtering on SFWT_FLAG to identify seeded rows that should not be manually edited.

Related Objects

The metadata reports no enforced foreign keys, so the following relationships are inferred from naming and standard EBS translation conventions rather than from documented FK constraints.

• OKL_EXT_AP_HEADER_SOURCES (base table) — related on HEADER_EXTENSION_ID; holds the untranslated header source definition.
• OKL_EXT_AP_HEADER_SOURCES_TL_P — the primary key constraint on (HEADER_EXTENSION_ID, LANGUAGE).
• OKL_EXT_AP_HEADER_SOURCES_TL_U1 — the unique index enforcing the business-key candidate on the same columns.
• FND_LANGUAGES — validates the LANGUAGE and SOURCE_LANG values against installed languages.
• FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — determine which languages are available for translation rows.
• The AP header source extension APIs and concurrent programs in the OKL module that read these translated statuses when building external AP header records.

Because the object is classified as standalone, consultants should verify any parent linkage directly against the base table rather than relying on database-enforced referential integrity.