Search Results okc_rule_groups_tlh




Overview
Explore in AI Chat

Overview

OKC_RULE_GROUPS_TLH is a history (audit) table in the OKC — Contracts Core module of Oracle E-Business Suite, shipped in both release 12.1.1 and 12.2.2. It preserves prior versions of rows held in OKC_RULE_GROUPS_TL, the translation base table that stores the language-dependent descriptive attributes of contract rule groups. Rule groups act as containers that determine which business rules, templates, and validation logic apply when a contract of a given class or type is authored, negotiated, and executed.

Because the "_TLH" suffix denotes a translation history table, the object is populated by Oracle's multi-language support (MLS) framework rather than by ordinary transactional DML. Whenever a rule group's translated text is updated and the MLS infrastructure archives the superseded row, the previous values are written here, keyed by the language and the version of the base record. The table therefore supports audit reconstruction, translation drift analysis, and recovery of prior rule-group descriptions without depending on database flashback or backups.

The heuristic Data Vault classification mined from the foreign-key structure is standalone. In Data Vault terms this suggests the object behaves as a satellite-like historical store on a single business key rather than as a hub or link. The classification should be treated as a modeling suggestion: the table carries no outgoing joins to other business entities apart from the security-group reference, and its natural grain is the combination of identifier, language, and version.

Key Information Stored

The table documents twelve columns. The most significant are:

  • ID — surrogate identifier of the rule group; part of the composite primary key.
  • LANGUAGE — the NLS language code for the archived translation row; part of the composite primary key.
  • MAJOR_VERSION — the version marker distinguishing successive archived revisions of the same language row; part of the composite primary key.
  • SOURCE_LANG — the language in which the row was originally authored, preserved for MLS lineage reporting.
  • SFWT_FLAG — the standard "seed/force/what-if" translation flag used across Oracle MLS tables.
  • COMMENTS — free-text description of the rule group as it existed at that version.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle WHO columns recording row creation and last modification audit context.
  • SECURITY_GROUP_ID — the operating unit / security grouping, carrying a foreign key to FND_SECURITY_GROUPS.

Two unique indexes are documented: OKC_RULE_GROUPS_TLH_PK on (ID, LANGUAGE, MAJOR_VERSION) and OKC_RULE_GROUPS_TLH_U1, the business-key candidate on the same three columns. The distinction between the surrogate ID and the composite business key is important — the ID alone is not unique here, since multiple historical language versions coexist for one rule group.

Common Use Cases and Queries

Typical reporting includes reconstructing the description of a rule group as of a past date, comparing translations across languages, and auditing changes made to rule-group comments. A representative pattern reconstructs the most recent archived version for a given rule group:

  • Select ID, LANGUAGE, MAJOR_VERSION, COMMENTS, LAST_UPDATED_BY, LAST_UPDATE_DATE from OKC_RULE_GROUPS_TLH where ID = :rule_group_id order by MAJOR_VERSION desc.
  • Join OKC_RULE_GROUPS_TLH to OKC_RULE_GROUPS_TL on ID and LANGUAGE to compare current versus historical text.
  • Filter by SOURCE_LANG or LANGUAGE to analyze missing or stale translations.
  • Group by SECURITY_GROUP_ID to report rule-group history per operating unit.
  • Correlate with CREATION_DATE ranges to satisfy change-audit requests from legal or compliance.

Related Objects

The principal dependencies and reference points are:

  • OKC_RULE_GROUPS_TL — the base translation table for which this object is the history holder; joined on ID and LANGUAGE.
  • OKC_RULE_GROUPS_B — the base (language-independent) rule group table supplying the ID business key.
  • OKC_RULE_GROUPS_VL / _V — MLS views exposing current rule-group text.
  • OKC_RULES_B / OKC_RULES_TL — the rule definitions assigned to each rule group.
  • OKC_RULE_GROUPS_TLH.SECURITY_GROUP_ID → FND_SECURITY_GROUPS — documented foreign key controlling row-level security.
  • FND_SECURITY_GROUPS — security definition table referenced by the above key.