Search Results oks_k_lines_tlh_u1

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

Overview

OKS.OKS_K_LINES_TLH is a translation (TL) table belonging to the Oracle Order Capture / Service Contracts (OKS) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The suffix "TLH" denotes a translated table pattern characteristic of the Oracle Applications multi-language architecture: the base table stores language-independent transactional data, while a companion TL table stores the language-dependent descriptive text keyed by a language code. This table holds translated descriptive attributes associated with service contract and subscription line identifiers, including free-form text fields such as INVOICE_TEXT, IB_TRX_DETAILS, STATUS_TEXT, and REACT_TIME_NAME. It resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, and its unique index OKS_K_LINES_TLH_U1 is placed in the APPS_TS_TX_IDX tablespace.

From a Data Vault modeling perspective, the mined relationship structure classifies this object heuristically as a standalone table. In practical terms, its composite key of ID, MAJOR_VERSION, and LANGUAGE behaves much like a satellite keyed on a parent entity plus language, holding descriptive, time-versioned text attributes rather than participating in a large hub-and-link network. The only documented foreign key reference is to FND_SECURITY_GROUPS via SECURITY_GROUP_ID.

Key Information Stored

The documented schema comprises 15 columns. The most significant are described below.

• ID (NUMBER) — Surrogate identifier linking the translated text back to its parent contract or subscription line entity. It forms the leading column of the primary key.
• MAJOR_VERSION (NUMBER) — Version discriminator that distinguishes concurrent or historical versions of the same line ID, enabling version-aware translation.
• LANGUAGE (VARCHAR2 12) — Language code identifying the language of the stored text, such as "US" or "ESA".
• SOURCE_LANG (VARCHAR2 12) — Language of the source record from which this translation was derived.
• SFWT_FLAG (VARCHAR2) — Oracle seed-data flag indicating whether the row is a dictionary-installable seeded translation.
• INVOICE_TEXT (VARCHAR2 2000) — Translated invoice-related free-form text.
• IB_TRX_DETAILS (VARCHAR2 2000) — Translated interaction/transaction detail text.
• STATUS_TEXT (VARCHAR2 450) — Translated status description.
• REACT_TIME_NAME (VARCHAR2 450) — Translated name associated with reaction-time processing.
• SECURITY_GROUP_ID (NUMBER) — References FND_SECURITY_GROUPS and supports multi-tenant data separation.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard Oracle who-columns providing audit trail and concurrency metadata.

The surrogate/business key is documented by unique index OKS_K_LINES_TLH_U1 on (ID, LANGUAGE, MAJOR_VERSION), which the metadata corroborates as the primary key OKS_K_LINES_TLH_PK. This composite of ID plus LANGUAGE plus MAJOR_VERSION is the true uniqueness constraint; ID alone is not unique because multiple languages and versions coexist.

Common Use Cases and Queries

Typical usage retrieves translated descriptive text for a given line in a specified language. A representative query pattern joins the TL table to its base entity on the shared key columns and filters by language:

• Fetching translated text: SELECT ID, MAJOR_VERSION, INVOICE_TEXT, STATUS_TEXT, REACT_TIME_NAME FROM OKS.OKS_K_LINES_TLH WHERE LANGUAGE = 'US' AND ID = :line_id;
• Listing all available languages for a line: SELECT LANGUAGE FROM OKS.OKS_K_LINES_TLH WHERE ID = :line_id AND MAJOR_VERSION = :ver;
• Reporting on translation coverage by comparing the set of languages present against the base-language rows.
• Auditing stale translations using LAST_UPDATE_DATE relative to CREATION_DATE, or validating SOURCE_LANG consistency.

Note the Oracle warning that this object is intended for access from standard Oracle Applications programs; direct SQL should be confined to read-only reporting.

Related Objects

• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID, which ties each translated row to a security group for data isolation.
• OKS_K_LINES_TLH (APPS synonym/view) — The dependency listing notes that a database object named OKS_K_LINES_TLH is referenced; the APPS-layer synonym exposes this table to application code.
• OKS_K_LINES (base table, by OKS naming convention) — The language-independent parent entity joined on ID and MAJOR_VERSION.
• FND_LANGUAGES — Supplies the valid values for LANGUAGE and SOURCE_LANG.
• FND_USER — Resolves CREATED_BY and LAST_UPDATED_BY to application users for audit reporting.

The documented dependency section confirms that OKS_K_LINES_TLH does not itself reference any database object beyond the security-group foreign key, and that the principal referencing object is the APPS synonym layer.