Search Results oks_subscr_header_tl_u1

Overview

OKS.OKS_SUBSCR_HEADER_TL is the translation (multi-language support, MLS) table that extends OKS.OKS_SUBSCR_HEADER_B within the Oracle E-Business Suite Service Contracts (OKS) module. It stores the language-dependent descriptive attributes of subscription templates and subscription instances. For every single row in the base table OKS_SUBSCR_HEADER_B, one or more rows exist in OKS_SUBSCR_HEADER_TL — exactly one row per installed or entered language. This design allows a subscription template or instance to display its name, description, and comments in the native language of each user while maintaining a single logical business record.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as a standalone structure. It functions as a satellite-like table, hanging off the subscription header business key (ID) and carrying descriptive, non-identifying attributes keyed by LANGUAGE. Organizations should treat it as descriptive context rather than an independent hub of business identity.

Key Information Stored

The table is keyed jointly by ID and LANGUAGE. The ID column is the primary identifier in combination with LANGUAGE and is also a foreign key to OKS_SUBSCR_HEADER_B.ID, linking each translation row back to its base subscription header. The unique index OKS_SUBSCR_HEADER_TL_U1 (ID, LANGUAGE) enforces this one-row-per-language business rule and acts as the principal business-key candidate; the primary key constraint OKS_SUBSCR_HEADER_TL_PK is defined on (LANGUAGE, ID).

• NAME (VARCHAR2 240) — the translatable name of the subscription template or instance.
• DESCRIPTION (VARCHAR2 1995) — the translatable description of the template or instance.
• COMMENTS (VARCHAR2 1995) — user-entered comments, also translated per language.
• LANGUAGE (VARCHAR2 12) — the standard MLS language key identifying the language of the row.
• SOURCE_LANG (VARCHAR2 12) — the language in which the information was originally entered, used for MLS fallback behavior.
• SFWT_FLAG — "Some Field Was Touched," flagging that a value was modified in another language; noted as not fully implemented in 11i.
• Standard auditing columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — track record provenance.
• SECURITY_GROUP_ID — a legacy Virtual Private Database column, now obsolete, retained for hosting-era compatibility.

Common Use Cases and Queries

Typical usage retrieves translated subscription header text for a given language or joins translations to the base table for reporting. For example, to list all subscription instances in American English:

• SELECT t.id, t.name, t.description, t.comments FROM oks.oks_subscr_header_tl t WHERE t.language = 'US';
• Join pattern to reconstruct a full header: SELECT b.id, t.name, t.description FROM oks.oks_subscr_header_b b, oks.oks_subscr_header_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
• Identify untranslated records by comparing SOURCE_LANG against LANGUAGE, or locate rows where SFWT_FLAG indicates cross-language edits.
• Reporting on multilanguage coverage verifies that every base subscription header has at least one translation row via a NOT EXISTS anti-join against OKS_SUBSCR_HEADER_B.

Related Objects

• OKS.OKS_SUBSCR_HEADER_B — the base table; joined on ID = OKS_SUBSCR_HEADER_TL.ID, the mandatory parent of every translation row.
• OKS_SUBSCR_HEADER_TL_PK — primary key constraint on (LANGUAGE, ID).
• OKS_SUBSCR_HEADER_TL_U1 — unique index on (ID, LANGUAGE) enforcing one row per language.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID via foreign key, though the column is now obsolete.
• Subscription template/instance APIs and concurrent programs in OKS (such as subscription creation and translation maintenance) read and write this table.
• MLS infrastructure views (FND language tools) surface columns such as SOURCE_LANG and SFWT_FLAG for translation management.