Search Results oks_k_lines_tl_u1

Overview

OKS.OKS_K_LINES_TL is the translation (MLS) table for the Service Contracts line entity within the Oracle E-Business Suite Service Contracts (OKS) module. It stores language-specific descriptive attributes for contract lines that are defined in the base table OKS_K_LINES_B. The _TL suffix identifies the table as a multi-language support construct, meaning each row corresponds to a single translated attribute set for a given contract line and language combination. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its associated unique index OKS_K_LINES_TL_U1 resides in APPS_TS_TX_IDX.

From a Data Vault modeling perspective, this object is best classified as a satellite. It depends entirely on the base contract-line identifier (its parent hub or base entity) and the LANGUAGE discriminator, and it carries descriptive, non-key payload attributes such as INVOICE_TEXT, STATUS_TEXT, and REACT_TIME_NAME. The heuristic classification returned as "standalone" reflects that the table has no outgoing foreign keys within the mined relationship data apart from the obsolete SECURITY_GROUP_ID reference; however, functionally it remains a dependent satellite of the contract-line entity. The table is flagged Oracle Internal Use Only, and direct access outside standard Oracle Applications programs is not supported.

Key Information Stored

The primary key is OKS_K_LINES_TL_PK, defined on the composite of (ID, LANGUAGE). The same column pair forms the unique index OKS_K_LINES_TL_U1, which serves as the business-key candidate for this translation table. The ID column is the unique identifier linking each translation row to its Service Contract line in OKS_K_LINES_B; LANGUAGE is the standard MLS language primary key column.

• ID — surrogate key identifying the Service Contract line in OKS_K_LINES_B.
• LANGUAGE — language primary key; standard MLS column establishing the translation context.
• SOURCE_LANG — the source language of the record, used in MLS processing.
• INVOICE_TEXT — invoice text associated with every contract line and sub line; this value passes to Receivables (AR) and displays on the generated invoice.
• STATUS_TEXT — the status message returned by the pricing engine after a line or sub line is priced; stores "Success" on successful pricing or the actual error message on failure. Displayed in the Status field of the Price Calculation window for Service lines at the sub-line level and for Subscription lines.
• REACT_TIME_NAME — the user-entered reaction time name captured from the Coverage user interface.
• SFWT_FLAG and IB_TRX_DETAILS — documented as not used.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — capture standard WHO information.
• SECURITY_GROUP_ID — formerly used to build a Virtual Private Database for Hosting services; now obsolete.

Common Use Cases and Queries

Because OKS_K_LINES_TL holds MLS text, the most frequent access pattern is joining it to OKS_K_LINES_B on ID and filtering by the session or reporting LANGUAGE. A typical pricing-status report retrieves STATUS_TEXT for lines whose pricing failed:

SELECT b.id, b.line_number, t.status_text
  FROM oks_k_lines_b  b,
       oks_k_lines_tl t
 WHERE b.id = t.id
   AND t.language = USERENV('LANG')
   AND t.status_text <> 'Success';

Invoice-text validation queries identify contract lines whose INVOICE_TEXT propagates to Receivables, supporting reconciliation between OKS and AR. Coverage configuration reporting surfaces REACT_TIME_NAME for service coverage analysis. Multi-language deployment audits compare LANGUAGE and SOURCE_LANG values to confirm translation completeness. Because the object is marked Oracle Internal Use Only, queries should be read-only and preferably run through supported Oracle interfaces.

Related Objects

• OKS.OKS_K_LINES_B — the base contract-line table; joined on ID. This is the parent entity for the translation satellite.
• OKS_K_LINES_TL_PK — primary key constraint on (ID, LANGUAGE).
• OKS_K_LINES_TL_U1 — the unique index on (ID, LANGUAGE) referenced in the user's search.
• FND_SECURITY_GROUPS — referenced by the obsolete SECURITY_GROUP_ID foreign-key relationship.
• FND_LANGUAGES — standard MLS reference for valid LANGUAGE codes.
• AR invoice interfaces — consume INVOICE_TEXT as passed from contract lines.