Results for “okc_k_headers_tl”

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

Overview

OKC_K_HEADERS_TL is the translatable (language-dependent) child table of OKC_K_HEADERS_B within the OKC – Contracts Core module of Oracle E-Business Suite. It stores the multi-lingual seed data (MLS) columns of a contract header record, allowing the same contract to present different descriptive text per installed language. The "TL" suffix follows Oracle's standard MLS convention: the "B" table holds language-independent columns shared across all languages, while the "TL" table holds the translatable text columns selected per session language.

The primary key is OKC_K_HEADERS_TL_PK, defined on (ID, LANGUAGE), and a unique index OKC_K_HEADERS_TL_U1 also exists on (ID, LANGUAGE), which serves as the business-key candidate. The table is owned by the OKC schema and is classified as VALID in the data dictionary. Under a heuristic Data Vault classification derived from foreign-key structure, this object is best modelled as a satellite — it carries descriptive, language-variant attributes of a contract header hub/link keyed by contract ID.

Key Information Stored

The table contains 17 documented columns. The most important include:

• ID – Contract header identifier; part of the composite primary key and the join back to OKC_K_HEADERS_B.
• LANGUAGE – Installed language code (e.g., US, D); the second component of the primary key.
• SOURCE_LANG – The language in which the record was originally authored, used by MLS to track translation origin.
• SFWT_FLAG – "Seed/translated" flag used by Oracle's translation tooling to indicate whether a row has been translated.
• SHORT_DESCRIPTION – Brief contract name/label displayed in list-of-values and query windows.
• DESCRIPTION – Full translatable narrative description of the contract header.
• COMMENTS – Free-text user comments attached to the header, translated per language.
• COGNOMEN – Additional translatable identifier text for the contract.
• NON_RESPONSE_REASON and NON_RESPONSE_EXPLAIN – Reason codes and explanatory text recorded when a party does not respond to a contract action.
• SET_ASIDE_REASON – Translatable reason text associated with set-aside processing on the contract.
• SECURITY_GROUP_ID – Foreign key referencing FND_SECURITY_GROUPS, supporting multi-tenant/security group isolation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Oracle WHO columns for audit and concurrency control.

The surrogate key is the composite (ID, LANGUAGE); the unique index OKC_K_HEADERS_TL_U1 corroborates this as the candidate business key. The SECURITY_GROUP_ID column is the sole documented foreign key, linking to FND_SECURITY_GROUPS.

Common Use Cases and Queries

Typical reporting and enquiry scenarios join the TL table to the base table to retrieve language-specific descriptions. A representative query pattern is:

• Contract listing by description in the user's language:
  SELECT h.id, t.short_description, t.description FROM okc_k_headers_b h, okc_k_headers_tl t WHERE h.id = t.id AND t.language = USERENV('LANG') AND h.security_group_id = :sg;
• Translation coverage audit — detect headers lacking a translated TL row for a required language by counting DISTINCT ID per LANGUAGE.
• Change/data-migration extracts that pull only translatable columns from OKC_K_HEADERS_TL to rebuild contract text in another environment.
• Comments and non-response reason reporting for contract dispute workflows, filtered on NON_RESPONSE_REASON.

Always constrain by LANGUAGE to avoid Cartesian duplication across installed languages; the DOO/Oracle seed data typically maintains one row per (ID, LANGUAGE).

Related Objects

• OKC_K_HEADERS_B – Base language-independent contract header table; join on ID. Every TL row corresponds to one B row.
• OKC_K_HEADERS_V – MLS view combining B and TL columns; the most common application-facing access point.
• FND_SECURITY_GROUPS – Referenced via SECURITY_GROUP_ID; governs which contracts are visible to a given security group.
• FND_LANGUAGES – Not a declared FK but the semantic lookup for the LANGUAGE column.
• OKC_K_LINES_B / OKC_K_LINES_TL – Contract lines residing beneath the header; related through header ID.
• OKC_K_PARTS_B – Contract parties/roles tables linked to the header.
• OKC_K_ITEMS_B – Contract item/deliverable details associated with the header.
• OKC_CONTRACTS_PUB / OKC_API – Public APIs that create, update, and copy contract headers and therefore write to this table.

These objects form the core Contracts repository, with OKC_K_HEADERS_TL supplying the translated descriptive layer over the language-independent header definition.