Results for “okc_k_lines_bh”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKC_K_LINES_BH is a Contracts Core (OKC) base table that stores contract line definitions within Oracle E-Business Suite 12.1.1 and 12.2.2. According to the Oracle ETRM documentation, it is a mirror image of the base table OKC_K_LINES_B, intended to hold historical versions of contract line records. Each row represents a specific version of a contract line, identified by the combination of the line identifier and a major version number. This structure enables the retention of prior revisions when contract lines are modified, providing an audit and versioning backbone for the Contracts module.

From a Data Vault modeling perspective, the documented foreign key topology suggests a hub-leaning classification. The table's primary key (ID, MAJOR_VERSION) anchors a set of stable business keys that other tables reference, particularly OKE_K_LINES_H. The 96 documented columns include descriptive and pricing attributes consistent with a satellite-style payload, but the central role of the identifier-plus-version key positions this object closer to a hub with attached descriptive context.

Key Information Stored

The table's surrogate primary key is OKC_K_LINES_BH_PK, defined on the columns ID and MAJOR_VERSION. A unique index, OKC_K_LINES_BH_U1, covers the same column pair, making it the documented business-key candidate. The most significant columns include:

• ID — surrogate identifier for the contract line, also used in foreign key joins from OKE_K_LINES_H.
• MAJOR_VERSION — version indicator combined with ID to uniquely identify a line revision.
• LINE_NUMBER — human-readable line sequence within the contract.
• CHR_ID and CLE_ID — pointers to the contract header and line entity records, linking lines to their parent contract.
• STS_CODE and TRN_CODE — status and transaction codes reflecting line lifecycle state.
• START_DATE and END_DATE — effective period for the line.
• PRICE_UNIT, PRICE_NEGOTIATED, PRICE_TYPE, CURRENCY_CODE, UOM_CODE — pricing and unit-of-measure attributes.
• PRICE_LIST_ID and PRICE_LIST_LINE_ID — references into Oracle Advanced Pricing for list pricing.
• CUST_ACCT_ID — customer account associated with the line.
• PAYMENT_TERM_ID and INV_RULE_ID — payment and invoicing rule references.
• DATE_TERMINATED, DATE_CANCELLED, CANCELLED_AMOUNT — termination and cancellation tracking.

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) and 15 descriptive ATTRIBUTE columns support concurrency control and extensibility.

Common Use Cases and Queries

Because this is a historical mirror, the most common query pattern filters by ID and MAJOR_VERSION to retrieve a specific revision. For example, joining to the current line table to compare revisions:

• Querying the latest version: SELECT * FROM OKC.OKC_K_LINES_BH WHERE ID = :line_id ORDER BY MAJOR_VERSION DESC;
• Retrieving all revisions of a contract's lines: joining on CHR_ID to group lines by contract header.
• Auditing pricing changes over time using PRICE_NEGOTIATED, PRICE_LIST_ID, and PRICE_LIST_LINE_ID.
• Reporting cancellation and termination activity through DATE_CANCELLED, DATE_TERMINATED, and CANCELLED_AMOUNT.
• Reconciling against OKE_K_LINES_H, which references this table via K_LINE_ID.

Related Objects

The documented foreign key structure connects OKC_K_LINES_BH to several surrounding objects:

• OKE_K_LINES_H — references this table through K_LINE_ID and MAJOR_VERSION; the primary dependent relationship.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for multi-org security.
• SO_PRICE_LIST_LINES_115 — referenced via PRICE_LIST_LINE_ID for pricing detail.
• MTL_INV_PICKING_RULES — referenced via INV_RULE_ID for shipping and inventory rules.
• PN_PAYMENT_TERMS_ALL — referenced via PAYMENT_TERM_ID for payment terms.
• OKC_K_LINES_B — the base table whose structure this historical mirror replicates.

Collectively, these dependencies make OKC_K_LINES_BH a central versioning store for contract line data, supporting audit, renewal, and pricing integrity across the Contracts Core module.