Search Results okc_condition_lines_bh_u1

Overview

OKC.OKC_CONDITION_LINES_BH is the history table for OKC_CONDITION_LINES_B within the Oracle E-Business Suite Contracts (OKC) module. In EBS 12.1.1 and 12.2.2, the OKC schema manages contract terms, conditions, and rule structures used by Oracle Contracts, Oracle Order Management, and related quoting and pricing flows. The "_BH" suffix denotes an audit/history companion table that captures prior versions of condition line records whenever a condition line is versioned or updated.

The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10. Under a heuristic Data Vault classification, this object can be modeled as a satellite: it records descriptive, time-stamped attributes tied to a parent business key (ID) qualified by MAJOR_VERSION, which together form the primary key OKC_CONDITION_LINES_BH_PK. Each row represents a snapshot of a condition line as it existed at a given contract version, making the object well suited to point-in-time and historical reporting.

Key Information Stored

The table carries 44 columns, of which the following are the most operationally significant:

• ID — System-generated unique identifier for the condition line; part of the composite primary key and of the unique index OKC_CONDITION_LINES_BH_U1 (ID, MAJOR_VERSION).
• MAJOR_VERSION — The contract version associated with this history record; the second component of the primary key and unique index, providing the versioning dimension.
• CNH_ID — Foreign key to OKC_CONDITION_HEADERS_B, tying the line to its parent condition header.
• DNZ_CHR_ID — Contract identifier link; indexed by the non-unique index OKC_CONDITION_LINES_BH_N1 for efficient retrieval by contract.
• PDF_ID and AAE_ID — Reference keys described in OKC_CONDITION_LINES_B, linking to pricing/attribute entities.
• LEFT_CTR_MASTER_ID, RIGHT_CTR_MASTER_ID, LEFT_COUNTER_ID, RIGHT_COUNTER_ID — Counterparty identifiers on the left and right operands of the condition.
• SORTSEQ and LOGICAL_OPERATOR — Sequencing and Boolean joining logic for the condition line.
• CNL_TYPE — The condition line type discriminator.
• RELATIONAL_OPERATOR, LEFT_PARENTHESIS, RIGHT_PARENTHESIS, RIGHT_OPERAND, TOLERANCE — Expression-building columns that construct the condition's evaluation rule.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing data-security access control.
• Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus OBJECT_VERSION_NUMBER — audit and optimistic-locking tracking.

The primary key is the surrogate composite (ID, MAJOR_VERSION) rather than ID alone, reflecting the history semantics: multiple rows per ID are expected, one per contract version.

Common Use Cases and Queries

Typical scenarios include auditing condition changes across contract revisions, reconstructing the state of a condition line as of a specific version, and comparing current versus historical rule structures.

• Retrieve all historical versions of a condition line:
  SELECT id, major_version, cnl_type, relational_operator, last_update_date FROM okc.okc_condition_lines_bh WHERE id = :p_id ORDER BY major_version;
• Report all condition lines for a contract as of a version:
  SELECT * FROM okc.okc_condition_lines_bh WHERE dnz_chr_id = :p_chr AND major_version = :p_ver;
• Audit changes within a date window:
  SELECT id, major_version, created_by, creation_date FROM okc.okc_condition_lines_bh WHERE last_update_date BETWEEN :p_from AND :p_to;

Because of the composite key, joins to OKC_CONDITION_LINES_B should always match on both ID and MAJOR_VERSION.

Related Objects

• OKC.OKC_CONDITION_LINES_B — The base (current) table; history rows are copied here on versioning via ID/MAJOR_VERSION.
• OKC.OKC_CONDITION_HEADERS_B — Parent header referenced by CNH_ID.
• OKC.OKC_CONDITION_LINES_TL — Translation table providing language-specific text for condition lines.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for access control (documented FK).
• FND_APPLICATION — Referenced by APPLICATION_ID for the owning application.
• OKC.OKC_CONDITION_LINES_BH_U1 — Unique index (ID, MAJOR_VERSION) enforcing the business key.