Search Results oks_k_lines_tl_pk

Overview

OKS_K_LINES_TL is the translation table for Service Contracts line text attributes within the Oracle E-Business Suite (EBS) Service Contracts (OKS) module. It stores language-specific, multi-lingual descriptive and textual content associated with contract lines managed by the OKS schema. As a "_TL" (translation) table, it participates in Oracle's standard Multi-Language Support (MLS) architecture, where the base table holds language-neutral operational data and the corresponding translation table holds the human-readable text values keyed by LANGUAGE. In EBS 12.1.1 and 12.2.2 the table is owned by the OKS schema and is reported as VALID.

From a Data Vault modeling perspective, the metadata's heuristic classification is standalone. This suggests the table is best modeled as a satellite-like structure attached to its parent contract-line entity rather than as a hub or a link in its own right, since it carries descriptive attributes (free text and status descriptions) that change independently of the core contract-line identity. The only mined foreign-key relationship points to FND_SECURITY_GROUPS via SECURITY_GROUP_ID, reinforcing that the table carries reference and descriptive text rather than transactional key structure.

Key Information Stored

The table is documented with 14 physical columns. Its primary key is the composite OKS_K_LINES_TL_PK (ID, LANGUAGE), which uniquely identifies the translated text row for a given contract line and language. The business-key candidate is captured by the unique index OKS_K_LINES_TL_U1 (ID, LANGUAGE), confirming that a single line may hold at most one translation row per installed language. The most significant columns include:

• ID — the surrogate identifier linking the translated row to its parent contract-line record.
• LANGUAGE — the installed language code for the translated values; together with ID it forms the primary and unique key.
• SOURCE_LANG — indicates the language from which the row's text was derived, supporting Oracle's "source language" tracking in MLS.
• SFWT_FLAG — the standard "Seed/Force/Whichever" translation flag used in MLS tables to govern the source-language update rule.
• INVOICE_TEXT — the language-specific invoice/billing text for the contract line.
• IB_TRX_DETAILS — translated detail text describing the instalment/transaction information for the line.
• STATUS_TEXT — the localized status description associated with the line.
• REACT_TIME_NAME — the localized name for the response/reaction time attribute of the line.
• SECURITY_GROUP_ID — the reference to FND_SECURITY_GROUPS controlling access; this is the documented foreign key.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO columns for audit and concurrent-program tracking.

Common Use Cases and Queries

Typical usage centers on retrieving localized line text for reporting and user-facing forms, ensuring that contract documentation renders in the operator's session language. A common pattern joins the translation row to the source line and filters by language, using NVL to fall back to the source language when a translation is missing:

• Localized line-text extraction: SELECT t.id, t.language, t.invoice_text, t.status_text, t.react_time_name FROM oks_k_lines_tl t WHERE t.language = USERENV('LANG') AND t.id = :line_id;
• Language availability audit across lines, joining OKS_K_LINES_TL to the base line table on ID to detect untranslated records.
• Reporting of invoice and instalment text for printed or extracted contract documents.
• Security-scoped queries filtering SECURITY_GROUP_ID against FND_SECURITY_GROUPS for multi-org access control.
• Data-quality reconciliation comparing STATUS_TEXT and REACT_TIME_NAME values across languages.

Related Objects

The following objects are the most significant related entities, based on the documented foreign-key and key structure:

• FND_SECURITY_GROUPS — referenced by OKS_K_LINES_TL.SECURITY_GROUP_ID.
• The OKS_K_LINES base table — the language-neutral parent whose ID is joined to OKS_K_LINES_TL.ID.
• OKS_K_LINES_TL_PK — the primary key constraint on (ID, LANGUAGE).
• OKS_K_LINES_TL_U1 — the unique business-key index on (ID, LANGUAGE).
• FND_LANGUAGES — the installed-language reference validating the LANGUAGE value.
• Other OKS *_TL translation tables — sibling MLS objects sharing the SOURCE_LANG and SFWT_FLAG conventions.

Because the mined relationship data classifies this object as standalone, dependents are limited to MLS and security-reference joins rather than operational child transactions.