Search Results okc_rules_tlh




Overview
Explore in AI Chat

Overview

OKC_RULES_TLH is the history (audit) table associated with OKC_RULES_TL, the translation-enabled base table that stores rule definitions for Oracle Contracts Core (OKC) in Oracle E-Business Suite 12.1.1 and 12.2.2. Rules in OKC govern contract clause and contract template behavior, driving clause substitution, conditional text generation, and contract authoring defaults. Because OKC_RULES_TL supports Oracle's multi-language (translation) framework, its history counterpart OKC_RULES_TLH captures the same logical row across languages and versions, preserving prior states whenever a rule record is created, updated, or superseded.

The table resides in the OKC schema and is classified as VALID in the data dictionary. The heuristic Data Vault classification mined from its foreign-key structure is standalone; from a modeling perspective, this suggests it behaves as an independent satellite-like structure rather than a hub or link. In practical terms, it functions as a versioned shadow of the base rule translation table rather than as a central integration point for other entities.

Key Information Stored

OKC_RULES_TLH carries 13 documented columns. The most significant include:

  • ID — Surrogate/candidate business identifier inherited from the base rule record in OKC_RULES_TL.
  • LANGUAGE — Language code for the translated rule text, part of the composite key.
  • MAJOR_VERSION — Version number that, together with ID and LANGUAGE, uniquely identifies a historical row. This is the column that distinguishes one historical snapshot from another.
  • SOURCE_LANG — The source language from which the translation was derived.
  • SFWT_FLAG — The "Seed/Foundation With Translation" flag used by the translation framework to indicate whether the row is a translatable seed row.
  • COMMENTS — Descriptive comments attached to the rule record.
  • TEXT — The actual rule text or rule definition content being versioned and translated.
  • CREATED_BY / CREATION_DATE — Standard WHO columns recording the creating user and timestamp.
  • LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard WHO columns capturing the most recent modification user, timestamp, and login session.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group isolation.

The primary key is OKC_RULES_TLH_PK, defined on (ID, LANGUAGE, MAJOR_VERSION). A unique index, OKC_RULES_TLH_U1, covers the same three columns, confirming them as the business-key candidate. The SECURITY_GROUP_ID column carries the sole documented foreign key, referencing FND_SECURITY_GROUPS.

Common Use Cases and Queries

Because OKC_RULES_TLH is an audit/history table, its principal uses are historical reporting, change tracking, and version comparison for contract rules. Typical SQL patterns include retrieving all versions of a given rule:

  • SELECT id, language, major_version, text, last_updated_by, last_update_date FROM okc.okc_rules_tlh WHERE id = :rule_id ORDER BY major_version DESC;
  • Comparing the current base row to its prior history: SELECT t.id, t.text AS current_text, h.text AS prior_text FROM okc_rules_tl t, okc_rules_tlh h WHERE t.id = h.id AND t.language = h.language AND h.major_version = t.major_version - 1;
  • Audit reporting filtered by security group: SELECT ... FROM okc_rules_tlh WHERE security_group_id = :sg_id AND last_update_date >= :from_date;

Reporting scenarios include rule-change audits, translation completeness checks across languages, and troubleshooting why a specific clause rendered differently at a past point in time.

Related Objects

The most significant related objects are:

  • OKC_RULES_TL — The base translation table for which OKC_RULES_TLH is the history; joined on ID, LANGUAGE, and MAJOR_VERSION.
  • OKC_RULES_B — The base (non-translated) rules table, joined via ID to the translation layer.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID to enforce data security.
  • FND_LANGUAGES — Implicitly referenced via the LANGUAGE column for translation validation.
  • OKC_RULE_* dependent configuration tables — Rules defined here feed clause and template processing.