Search Results okc_k_lines_bh

Overview

The OKC_K_LINES_BH table is a history table within the Oracle Contracts Core (OKC) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is designed to store historical versions of contract line records. Its primary role is to maintain a complete audit trail of changes made to the primary contract lines table, OKC_K_LINES_B. This is a critical component for supporting the versioning and amendment functionality of contracts, ensuring that a complete record of all line-level modifications is preserved for compliance, reporting, and historical analysis.

Key Information Stored

The table stores snapshots of contract line data as it existed at different points in time. Its structure mirrors that of its base table, OKC_K_LINES_B, with the addition of versioning metadata. The primary key is a composite key consisting of the ID (the contract line identifier) and the MAJOR_VERSION number. This combination uniquely identifies each historical version of a contract line. Typical columns include all attributes of a contract line, such as description, quantity, pricing, dates, and associated item or service information, captured at the moment a version was created. The MAJOR_VERSION column is the key indicator for tracking the sequence of changes.

Common Use Cases and Queries

The primary use case is auditing and reporting on the evolution of a contract line. This is essential for understanding what changed, when, and why during the contract's lifecycle, especially after amendments. Common queries involve retrieving the full version history for a specific contract line or comparing different major versions to identify specific field-level changes. For example, to see all historical versions for a line, one might use:

• SELECT * FROM okc_k_lines_bh WHERE id = :line_id ORDER BY major_version;

Another critical use case is integration with the Oracle Projects Contracts (OKE) module, as indicated by the foreign key relationship. Reports that need to correlate project contract line history with the core contract line history will join on the ID and MAJOR_VERSION columns.

Related Objects

The table has a direct and foundational relationship with several key objects in the Contracts Core and Projects Contracts modules. Its base table is OKC_K_LINES_B, from which it receives its core data structure. A significant foreign key relationship exists with the Oracle Projects Contracts table OKE_K_LINES_H, where OKE_K_LINES_H.K_LINE_ID and OKE_K_LINES_H.MAJOR_VERSION reference the primary key columns of OKC_K_LINES_BH. This link integrates project-specific contract line history with the core contract line history. The table is also referenced by various Contracts Core APIs and user interface forms that manage contract versioning and amendments.