Search Results okc_price_adj_assocs_h




Overview
Explore in AI Chat

Overview

The OKC_PRICE_ADJ_ASSOCS_H table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module. Its primary function is to establish and maintain the historical associations between price adjustments and the specific business objects for which the price has been modified. This table serves as a critical junction point in the pricing architecture, enabling the application to track which price adjustments (such as discounts, surcharges, or rebates) have been applied to individual contract lines, billing lines, or other chargeable entities. By maintaining these associations, the system supports complex pricing models, audit trails, and accurate financial calculations for contractual agreements.

Key Information Stored

While the full column list is not detailed in the provided metadata, the foreign key relationships explicitly define the core identifiers stored in this table. The primary key is a column named ID. The table's essential foreign key columns store references to the associated objects. These include PAT_ID and PAT_ID_FROM, which link to the OKC_PRICE_ADJUSTMENTS table, identifying the specific price adjustment rule applied. The table also holds identifiers for the adjusted objects: CLE_ID for contract lines (OKC_K_LINES_B), BSL_ID for subscription billing lines (OKS_BILL_SUB_LINES), and BCL_ID for contract billing lines (OKS_BILL_CONT_LINES). The "_H" suffix in the table name typically indicates it is a history table, designed to retain a record of associations over time, which is crucial for auditing and reporting on pricing changes.

Common Use Cases and Queries

A primary use case is tracing the lineage of price calculations on a contract line for audit or dispute resolution. Analysts can query this table to identify all price adjustments that have ever been applied to a specific line item. Another common scenario is generating reports on discount utilization across a portfolio of contracts. Sample SQL to find adjustments for a contract line would involve joining to the price adjustments table to get rule details.

SELECT pa.NAME, pa.ADJUSTMENT_TYPE, h.*
FROM okc_price_adj_assocs_h h,
     okc_price_adjustments pa
WHERE h.pat_id = pa.id
  AND h.cle_id = :contract_line_id
ORDER BY h.id;

Data from this table is also fundamental for recreating the pricing history of a subscription or billing line during renewal or amendment processes.

Related Objects

The table has documented foreign key relationships with several core Contracts and Service Contracts tables, as per the provided metadata:

  • OKC_PRICE_ADJUSTMENTS: Linked via PAT_ID. This is the master table for price adjustment definitions.
  • OKC_PRICE_ADJUSTMENTS: Also linked via PAT_ID_FROM, indicating a potential relationship for adjustment chaining or tiered pricing.
  • OKS_BILL_SUB_LINES: Linked via BSL_ID. Associates adjustments to subscription billing lines in Service Contracts.
  • OKC_K_LINES_B: Linked via CLE_ID. Associates adjustments to the base contract lines.
  • OKS_BILL_CONT_LINES: Linked via BCL_ID. Associates adjustments to contract billing lines in Service Contracts.

The primary key constraint OCO_38752142 on the ID column ensures each association record is uniquely identifiable. These relationships position OKC_PRICE_ADJ_ASSOCS_H as a central hub for pricing data integration between the Contracts Core and Service Contracts modules.