Search Results okc_sections_bh




Overview
Explore in AI Chat

Overview

OKC_SECTIONS_BH is an Oracle E-Business Suite table owned by the OKC schema (Contracts Core). It serves as the history (audit) table that mirrors its base table, OKC_SECTIONS_B, capturing successive versions of contract section records. In EBS 12.1.1 and 12.2.2, the "_BH" suffix designates a date-tracked history table that preserves the full lifecycle of a row, so any change made to the corresponding base record generates a new historical version keyed by a major version number rather than overwriting the prior state.

The table is classified heuristically as standalone within a Data Vault model. This classification is offered as a modeling suggestion only; the table's structure suggests it behaves as a satellite-like history store rather than a hub or link, since it holds descriptive attributes and versioning information around the contract section entity rather than the pure business keys that would define a hub.

Key Information Stored

The primary key, enforced by OKC_SECTIONS_BH_PK, is composed of ID and MAJOR_VERSION. ID identifies the underlying contract section, and MAJOR_VERSION distinguishes each historical instance of that section. A unique index, OKC_SECTIONS_BH_U1, also covers (ID, MAJOR_VERSION), reinforcing the natural business-key candidate for the version record.

Among the 46 documented columns, the most significant include:

Common Use Cases and Queries

This table supports auditing and point-in-time reconstruction of contract sections. Typical reporting includes comparing a section's current state against prior versions, tracing the sequence of amendments, and identifying who changed a section and when.

  • Retrieve the full version history of a section:
    SELECT id, major_version, label, heading, amendment_operation_code, last_amended_by, last_amendment_date FROM okc.okc_sections_bh WHERE id = :section_id ORDER BY major_version;
  • Find the most recent version:
    SELECT * FROM okc.okc_sections_bh WHERE id = :section_id AND major_version = (SELECT MAX(major_version) FROM okc.okc_sections_bh WHERE id = :section_id);
  • Audit report of amendments by date range:
    SELECT id, scn_id, amendment_operation_code, last_amended_by, last_amendment_date FROM okc.okc_sections_bh WHERE last_amendment_date BETWEEN :from_date AND :to_date;

Because rows are versioned, joins back to the current contract document should use SCN_ID or DOCUMENT_ID rather than assuming a single row per section.

Related Objects

The table's documented foreign key points to FND_SECURITY_GROUPS via SECURITY_GROUP_ID, tying section history to security group definitions. Functionally, its closest relationship is to its base table, OKC_SECTIONS_B, from which every historical row originates. Related objects include:

  • OKC_SECTIONS_B — the current/base section table mirrored by this history table.
  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID.
  • OKC_CONTRACTS / contract document objects — referenced through DOCUMENT_ID and DOCUMENT_TYPE.
  • OKC section amendment APIs — the contracts amendment logic that writes these history records.

Querying by ID and MAJOR_VERSION provides the most reliable access path given the documented primary and unique indexes.