Search Results okc_sections_tl_pk

Overview

OKC_SECTIONS_TL is a translation (MLS) table in the Oracle Contracts Core (OKC) product schema. Its documented purpose is to hold the translatable columns from OKC_SECTIONS_B, following Oracle Multi-Lingual Support (MLS) standards. The table is explicitly marked in the ETRM metadata as obsolete, having been obsoleted in release 11.5.10. Consequently, in Oracle EBS 12.1.1 and 12.2.2 the object persists in the schema for backward compatibility and upgrade integrity, but it is not part of the active Contracts data model.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is standalone. This suggests that OKC_SECTIONS_TL is best treated as an independent structure rather than as a conventional hub or link. Where a warehouse model is derived from the EBS Contracts schema, this table is most naturally modeled as a satellite-type structure attached to the section entity, since it carries descriptive, language-dependent attributes keyed by the parent section identifier and language code.

Key Information Stored

The table contains eleven documented columns in the 12.2.2 physical schema. The most significant are:

• ID — Surrogate identifier of the parent section row in OKC_SECTIONS_B. It forms part of the composite primary key.
• LANGUAGE — The language code for the translated row, also part of the primary key and the driving column of the MLS design.
• SOURCE_LANG — The source language of the row, used by MLS to track the origin language of the translation.
• SFWT_FLAG — The standard MLS "seed from which translated" flag indicating whether the row was seeded from the source language record.
• HEADING — The translatable descriptive text for the section heading. This is the primary business attribute carried in the _TL table.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-tenant data isolation.
• CREATED_BY, CREATION_DATE — Standard EBS audit columns recording row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording the last modification and the login session that performed it.

The primary key is OKC_SECTIONS_TL_PK on (ID, LANGUAGE). A unique index, OKC_SECTIONS_TL_U1, is documented on the same (ID, LANGUAGE) pair, confirming that this combination is the business-key candidate for the table.

Common Use Cases and Queries

Because the table is obsolete, production reporting against it should be avoided in 12.1.1 and 12.2.2. Its principal legitimate uses are historical data migration, upgrade verification, and archival extraction. A typical archival query joins the translation row back to its base table:

• SELECT t.ID, t.LANGUAGE, t.HEADING FROM OKC.OKC_SECTIONS_TL t WHERE t.LANGUAGE = 'US';
• SELECT b.ID, t.LANGUAGE, t.HEADING FROM OKC.OKC_SECTIONS_B b, OKC.OKC_SECTIONS_TL t WHERE b.ID = t.ID;
• Extraction for legacy reporting: filter by CREATION_DATE or LAST_UPDATE_DATE ranges to identify rows created before the obsolescence point.

Reporting use cases are limited to legacy contract section heading translations that were captured prior to the 11.5.10 obsolescence. Analysts should verify whether equivalent data now resides in the successor structure before relying on this table.

Related Objects

The documented relationship metadata identifies the following significant dependencies:

• OKC_SECTIONS_B — The base (non-translatable) table supplying the ID that OKC_SECTIONS_TL references; the natural join is on ID.
• OKC_SECTIONS_TL_PK — Primary key constraint on (ID, LANGUAGE).
• OKC_SECTIONS_TL_U1 — Unique index on (ID, LANGUAGE), the business-key candidate.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID, governing row-level security group assignment.
• FND_LANGUAGES — The standard MLS lookup that validates values in the LANGUAGE column.

Because the object is standalone and obsolete, no active Contracts Core APIs or views should depend upon it. Any remaining references are expected to be legacy only.