Results for “inv_agrmnt_status”

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

Overview

OKL_EXT_AR_HEADER_SOURCES_TL is a translation (TL) table in the OKL schema, the foundation of Oracle E-Business Suite's Leasing and Finance Management module. It stores language-specific, translatable descriptive attributes for external Auto-Renewal (AR) header extension sources. In Oracle EBS Release 12.1.1 and 12.2.2, TL tables conform to the multi-language support (MLS) architecture, holding one row per translatable entity per installed language. Here each row is keyed by a combination of HEADER_EXTENSION_ID and LANGUAGE, allowing the same logical header source definition to present localized text in each active language.

The object functions as a configuration and reference repository rather than a transactional table. It describes how leasing contract statuses, agreement statuses, and transaction types should be interpreted when external AR headers are sourced into OKL processing. Based on the foreign-key and primary-key heuristic applied to the documented structure, this object is best modeled as a standalone data object. The isolated primary key (HEADER_EXTENSION_ID, LANGUAGE) with no outgoing FK dependencies to other tables supports classifying it as a standalone reference entity rather than a hub, link, or satellite in a Data Vault sense. This classification is a modeling suggestion, not a documented ETRM attribute.

Key Information Stored

The table contains 12 documented columns. The most significant are:

• HEADER_EXTENSION_ID — The surrogate identifier linking each translated row to its base header extension source. This is the primary key component that groups all language rows for a single logical entity.
• LANGUAGE — The installed Oracle language code for the row, completing the composite primary key.
• SOURCE_LANG — The language of the source text from which the translation derives; used by MLS tooling to track translation provenance.
• SFWT_FLAG — The "Seed/Factory-With-Translation" indicator distinguishing seed data shipped by Oracle from customer-maintained rows.
• CONTRACT_STATUS — Localized contract status description associated with the header source.
• INV_AGRMNT_STATUS — Localized invoice agreement status value tied to the external AR header source.
• TRANSACTION_TYPE_NAME — The translatable name of the transaction type mapped to this header source.
• CREATED_BY, CREATION_DATE — Standard audit columns capturing row creation context.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns tracking the last modification.

The documented unique index OKL_EXT_AR_HEADER_SRCS_TL_U1 (HEADER_EXTENSION_ID, LANGUAGE) mirrors the primary key OKL_EXT_AR_HEADER_SRCS_TL_PK, reinforcing the composite business key.

Common Use Cases and Queries

Typical usage centers on retrieving localized status and transaction type descriptions when displaying or validating external AR header source configuration. A representative query joins the TL row to its base table and filters by language:

• Listing all header sources in a specific language: SELECT HEADER_EXTENSION_ID, CONTRACT_STATUS, TRANSACTION_TYPE_NAME FROM OKL_EXT_AR_HEADER_SOURCES_TL WHERE LANGUAGE = USERENV('LANG');
• Comparing translations across languages for a single source: SELECT LANGUAGE, INV_AGRMNT_STATUS FROM OKL_EXT_AR_HEADER_SOURCES_TL WHERE HEADER_EXTENSION_ID = :id;
• Auditing seed versus customer rows using SFWT_FLAG.
• Reporting on recently maintained translations via LAST_UPDATE_DATE.

Related Objects

Because the documented relationship data classifies this object as standalone, no explicit foreign keys are recorded. The principal reference is the untranslated base header sources table in the OKL schema, joined on HEADER_EXTENSION_ID. Other related objects include the OKL leasing contract tables that consume CONTRACT_STATUS and INV_AGRMNT_STATUS values, the transaction type reference tables that align with TRANSACTION_TYPE_NAME, and standard EBS MLS views (such as _VL variants) that expose translated content. The OKL AR header source setup forms and concurrent programs that seed this reference data also depend on the table.