Search Results okc_k_headers_tl

Overview

The table OKC_K_HEADERS_TL is a core translation table within the Oracle E-Business Suite Contracts Core (OKC) module for versions 12.1.1 and 12.2.2. As indicated by its name suffix '_TL', it follows the standard Oracle Multi-Language Support (MLS) architecture. Its primary role is to store the language-specific, translatable text for contract headers, which are primarily defined in the base table OKC_K_HEADERS_B. This separation allows a single contract header record in the base table to support multiple language translations for its descriptive attributes, enabling global deployment and localization of contract management data.

Key Information Stored

The table holds translated versions of textual columns from the associated base table. While the specific column list is not detailed in the provided metadata, standard '_TL' table design dictates it will contain at minimum a primary key composed of the record's unique identifier (the ID, which corresponds to the primary key from OKC_K_HEADERS_B) and the LANGUAGE code (e.g., 'US', 'DE', 'JA'). Other columns typically include translatable attributes such as the contract's short description, notes, or other user-facing text fields. The primary key constraint, OKC_K_HEADERS_TL_PK, enforces uniqueness on the combination of ID and LANGUAGE, ensuring only one translation per language exists for a given contract header.

Common Use Cases and Queries

This table is essential for any reporting or data extraction that must present contract header information in a user's session language. Applications and database views automatically join to this table using the session's language setting. Common operational queries include retrieving all translations for a specific contract or verifying the existence of a translation. A fundamental reporting pattern joins the base and translation tables:

• SELECT b.contract_number, tl.short_description FROM okc_k_headers_b b, okc_k_headers_tl tl WHERE b.id = tl.id AND tl.language = USERENV('LANG');

Data migration or translation management scripts may also query this table to audit or populate translations for newly created contracts.

Related Objects

The table has a direct and mandatory relationship with its base table, OKC_K_HEADERS_B, which stores the non-translatable contract header information. The ID column in OKC_K_HEADERS_TL is a foreign key to the primary key of OKC_K_HEADERS_B. This table is also referenced by various Contracts Core application forms, reports, and public application programming interfaces (APIs) that manage contract data. Database views that present contract information for reporting will typically perform an outer join to OKC_K_HEADERS_TL based on the user's session language to ensure text is displayed correctly.