Search Results oks_subscr_header_tl




Overview
Explore in AI Chat

Overview

OKS_SUBSCR_HEADER_TL is the translation (MLS) table for subscribed service contract headers within the Oracle Service Contracts (OKS) module. It stores the language-dependent descriptive attributes of a subscription header record whose language-independent attributes are held in the base table OKS_SUBSCR_HEADER_B. Oracle EBS implements Multi-Language Support (MLS) by splitting translatable text columns into a dedicated "_TL" table, allowing each subscription header to carry a distinct name, description, and comment string for every installed language.

In ETRM 12.1.1 and 12.2.2 the object resides in the OKS schema and is flagged VALID. It is owned by the Service Contracts product family and is a standard component of the contract authoring and reporting data model. Its primary key, OKS_SUBSCR_HEADER_TL_PK, is composite and defined on (LANGUAGE, ID); a unique index, OKS_SUBSCR_HEADER_TL_U1, is additionally defined on (ID, LANGUAGE), which acts as the business-key candidate and reinforces the one-row-per-language rule. From a Data Vault modeling perspective this object classifies heuristically as a satellite: it is keyed by the parent ID and LANGUAGE and carries descriptive, time-stamped, audited attributes that change independently of the hub entity.

Key Information Stored

The table consists of 13 documented columns. The most significant are listed below.

  • ID — Surrogate/foreign key referencing the parent row in OKS_SUBSCR_HEADER_B; part of the composite primary key and of the unique index.
  • LANGUAGE — The NLS language code of the translated row; the second component of the primary key.
  • SOURCE_LANG — The language in which the source text was originally entered, used by the MLS translation workflow.
  • NAME — The language-specific name of the subscribed service contract header.
  • DESCRIPTION — The language-specific description of the subscription.
  • COMMENTS — Free-form, language-dependent commentary attached to the header.
  • SFWT_FLAG — The "Seed/Force/Workflow Translation" flag tracking whether the row has been submitted for translation.
  • CREATED_BY, CREATION_DATE — Standard Who columns recording row creation.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns recording the most recent modification and the login session that made it.
  • SECURITY_GROUP_ID — The multi-org security group identifier; the table references FND_SECURITY_GROUPS on this column.

The surrogate primary key is (LANGUAGE, ID), while the unique index (ID, LANGUAGE) serves as the documented business-key candidate. The table is classified as standalone under the heuristic Data Vault mining of its foreign-key structure, though SECURITY_GROUP_ID links to FND_SECURITY_GROUPS.

Common Use Cases and Queries

Typical usage retrieves translated header text for contract inquiry, printing, and reporting. A standard pattern joins the translation table to the base table filtered by the user's session language:

  • Display a header in the run-time language: SELECT b.id, tl.name, tl.description FROM oks_subscr_header_b b, oks_subscr_header_tl tl WHERE b.id = tl.id AND tl.language = USERENV('LANG');
  • List all translations for one header: select NAME, DESCRIPTION, LANGUAGE from OKS_SUBSCR_HEADER_TL where ID = :id.
  • Audit stale translations: filter on SFWT_FLAG = 'N' combined with a LAST_UPDATE_DATE comparison against the base row.
  • Reporting extract: join to OKS_SUBSCR_HEADER_B and subordinate subscription lines to produce language-specific contract registers.

Because the table is queried by ID, the unique index OKS_SUBSCR_HEADER_TL_U1 provides efficient access paths for both single-row and bulk joins.

Related Objects

The table is tightly coupled to its base and configuration tables, as documented in the relationship metadata.

  • OKS_SUBSCR_HEADER_B — The base table holding language-independent attributes; joined on OKS_SUBSCR_HEADER_B.ID = OKS_SUBSCR_HEADER_TL.ID.
  • FND_SECURITY_GROUPS — Referenced through OKS_SUBSCR_HEADER_TL.SECURITY_GROUP_ID, enforcing multi-org security.
  • FND_LANGUAGES — Supplies the valid LANGUAGE and SOURCE_LANG values.
  • OKS_SUBSCR_LINES_B / _TL — Subscribed contract lines child objects that inherit the header context.
  • OKS_CONTRACTS / OKS_K_HEADERS and their translation tables — Parallel contract-header structures following the same MLS pattern.
  • OKS_SUBSCR_HEADER_TL_PK / _U1 — The primary-key and unique indexes governing access and integrity.