Search Results sys_il0000085389c00006

Overview

OKC.OKC_RULES_TL is the translation (MLS) table associated with OKC_RULES_B in the Oracle Contracts (OKC) module of Oracle E-Business Suite. It stores the language-dependent, translatable attributes of contract rule definitions — specifically the user-entered comments and the long text associated with each rule — for every installed language in the EBS instance. The "_TL" suffix is the standard Oracle Applications convention denoting a translation table that follows Multi-Lingual Support (MLS) standards, meaning one row exists per rule per language, tied to the base record in OKC_RULES_B through the shared ID column. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, confirming its classification as a transactional (OLTP) object rather than a reference or seed data table.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. That classification is reasonable: OKC_RULES_TL holds descriptive, language-specific context about rules rather than serving as a junction between two business entities or as a pure surrogate-key hub. It is best modeled as a satellite attached to the OKC_RULES_B hub, keyed by the combination of the rule ID and LANGUAGE.

Key Information Stored

The physical schema documents 12 columns. The most significant are:

• ID (NUMBER) — Primary key column; surrogate identifier shared with OKC_RULES_B. Together with LANGUAGE it forms the primary key OKC_RULES_TL_PK.
• LANGUAGE (VARCHAR2(12), mandatory) — Standard MLS column indicating the language of the row's translated content.
• SOURCE_LANG (VARCHAR2(12), mandatory) — Standard MLS column recording the language from which the translation was derived; used by the MLS translation tooling.
• COMMENTS (VARCHAR2(1995)) — The user-entered free-text comment for the rule in the target language.
• TEXT (CLOB(4000)) — A long-text column holding extended descriptive content for the rule. Because it is a CLOB, it carries an associated LOB segment (SYS_IL0000085389C00006$$) created in APPS_TS_TX_DATA.
• SFWT_FLAG (VARCHAR2) — Documented as not used; retained for MLS framework compatibility.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard "Who" audit columns recording insert and update provenance.
• SECURITY_GROUP_ID (NUMBER) — Used in hosted environments to partition data by security group; a foreign key references FND_SECURITY_GROUPS.

The business-key candidate is the unique index OKC_RULES_TL_U1 on (ID, LANGUAGE) in the APPS_TS_TX_IDX tablespace. This is the user search term "okc_rules_tl_u1" — the unique MLS index that guarantees one translation row per rule per language and is critical for query performance when joining back to the base table.

Common Use Cases and Queries

The primary practical use is retrieving human-readable rule text in a specific language, either by joining OKC_RULES_TL to OKC_RULES_B or by filtering LANGUAGE directly. A representative pattern:

• SELECT b.ID, t.LANGUAGE, t.COMMENTS, t.TEXT FROM OKC_RULES_B b, OKC_RULES_TL t WHERE b.ID = t.ID AND t.LANGUAGE = USERENV('LANG');
• Reporting on translation coverage: query OKC_RULES_TL grouped by LANGUAGE to confirm which rules have been translated.
• Verifying index usage: check the execution plan for OKC_RULES_TL_U1 on (ID, LANGUAGE) when diagnosing MLS join performance.
• Audit queries on CREATED_BY / LAST_UPDATED_BY to track who maintained rule text.

Related Objects

• OKC.OKC_RULES_B — The base table whose translatable columns this table mirrors; join on ID.
• OKC.OKC_RULES_TL# — The underlying dependent object referenced by this table per the ETRM dependency list.
• FND_SECURITY_GROUPS — Referenced via the SECURITY_GROUP_ID foreign key for hosted environments.
• FND_LANGUAGES — Implicit lookup validating LANGUAGE and SOURCE_LANG against installed languages.
• OKC_RULES_B_U1 — The parallel unique index on the base table (ID), paired with OKC_RULES_TL_U1 across the MLS pair.
• FND_MLS_* APIs — The standard MLS utility packages that populate and maintain this table through AD_DD/translation maintenance.