Search Results okc_ph_line_breaks_h




Overview
Explore in AI Chat

Overview

OKC_PH_LINE_BREAKS_H is a table in the OKC schema (Contracts Core) within Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM metadata, it is a history table that stores information about line breaks on a price hold. The object carries the annotation "Not Used," indicating that although the table and its supporting structures exist as part of the delivered schema, the corresponding functional flow — line break history tracking on price holds — is not active in the standard product. The table is therefore best understood as a dormant schema artifact retained for structural consistency and backward compatibility rather than as a live transactional object.

The documented physical schema consists of 24 columns owned by OKC, with a single-column primary key constraint, OKC_PH_LINE_BREAKS_H_PK, defined on the ID column. From a Data Vault modeling perspective, the metadata's heuristic classification is link, suggesting the table functions primarily as an associative entity connecting a contract line to organizational and shipping context. The presence of surrogate key ID, version column MAJOR_VERSION, and audit columns is consistent with a versioned history structure recording state changes over time.

Key Information Stored

The most significant columns documented in the schema include:

No secondary unique indexes are documented beyond the primary key; business-key candidates such as CLE_ID combined with version or break range are not formally enforced in the metadata.

Common Use Cases and Queries

Because the table is marked "Not Used," production reporting against it is uncommon. Where referenced, it is typically in the context of data lineage, schema impact analysis, or historical investigation of pricing/break configuration. A typical investigation query joins the table to its parent contract line:

  • Retrieve break definitions for a contract line: SELECT h.ID, h.CLE_ID, h.VALUE_FROM, h.VALUE_TO, h.VALUE, h.PRICING_TYPE FROM OKC.OKC_PH_LINE_BREAKS_H h WHERE h.CLE_ID = :cle_id;
  • Filter by effective dates: ... WHERE TRUNC(SYSDATE) BETWEEN h.START_DATE AND h.END_DATE;
  • Confirm multi-org security scope: SELECT DISTINCT h.SECURITY_GROUP_ID FROM OKC.OKC_PH_LINE_BREAKS_H h;
  • Trace pricing integration: SELECT h.QP_REFERENCE_ID FROM OKC.OKC_PH_LINE_BREAKS_H h WHERE h.INTEGRATED_WITH_QP = 'Y';

These patterns are useful for migration validation, data auditing, and confirming whether historical price-hold rows exist before decommissioning references to this object.

Related Objects

The documented foreign key relationships connect this table to the following significant objects:

  • OKC_K_LINES_B — via CLE_ID; the contract line base table that owns the price-hold line reference.
  • HR_ALL_ORGANIZATION_UNITS — via SHIP_TO_ORGANIZATION_ID; supplies organizational context.
  • FND_SECURITY_GROUPS — via SECURITY_GROUP_ID; enforces multi-org access boundaries.

Oracle Advanced Pricing tables are referenced indirectly through QP_REFERENCE_ID and the INTEGRATED_WITH_QP flag, and the base (non-history) counterpart object in the OKC.PH namespace should be considered when analyzing the complete price-hold break model. Any dependent views, APIs, or concurrent programs referencing OKC_PH_LINE_BREAKS_H should be validated before schema cleanup, given the "Not Used" classification.