Search Results okc_price_adj_assocs




Overview
Explore in AI Chat

Overview

The OKC_PRICE_ADJ_ASSOCS table is a core transactional entity within the Oracle E-Business Suite Contracts Core (OKC) module. Its primary function is to establish and maintain the associative relationships between price adjustment records and the specific business objects to which those adjustments are applied. This table acts as a critical junction, enabling the flexible application of pricing rules, discounts, or surcharges to various contract line items and billing lines. By managing these associations, it ensures accurate price derivation and financial calculations for contracts, which is fundamental to the revenue and billing processes in Oracle EBS.

Key Information Stored

The table's structure is designed to link a price adjustment to a target object via foreign key references. The most critical columns are the foreign key columns that define these relationships. The PAT_ID column references the primary key (ID) of the OKC_PRICE_ADJUSTMENTS table, identifying the specific price adjustment being applied. The table then uses one of several object-specific columns to point to the adjusted item: CLE_ID for contract lines (OKC_K_LINES_B), BCL_ID for billing contract lines (OKS_BILL_CONT_LINES), or BSL_ID for billing subscription lines (OKS_BILL_SUB_LINES). The PAT_ID_FROM column provides a secondary link to the OKC_PRICE_ADJUSTMENTS table, potentially used for tracking adjustment hierarchies or dependencies. The table's primary key is the ID column, ensuring each association record is uniquely identifiable.

Common Use Cases and Queries

This table is central to queries that analyze the pricing structure of contracts. A common reporting use case is to list all price adjustments applied to a specific contract line to understand its final price composition. Support and implementation teams often query this table to troubleshoot pricing discrepancies by verifying the associations between adjustments and lines. A typical SQL pattern involves joining OKC_PRICE_ADJ_ASSOCS to both the price adjustments and the relevant line table.

  • Sample Query: To find adjustments for a contract line:
    SELECT pa.* FROM okc_price_adj_assocs paa, okc_price_adjustments pa WHERE paa.cle_id = :contract_line_id AND paa.pat_id = pa.id;
  • Data Validation: Identifying orphaned associations where the target line or adjustment no longer exists.

Related Objects

The functionality of OKC_PRICE_ADJ_ASSOCS is defined by its documented foreign key relationships, which are integral to the Contracts and Service Contracts data model.

  • OKC_PRICE_ADJUSTMENTS: The primary source table for price adjustments, joined via PAT_ID (and optionally PAT_ID_FROM).
  • OKC_K_LINES_B: The core Contracts table for line items. Associations are made using the CLE_ID column.
  • OKS_BILL_CONT_LINES & OKS_BILL_SUB_LINES: Key billing line tables from the Service Contracts (OKS) module. Associations are made via BCL_ID and BSL_ID, respectively, demonstrating integration between Contracts Core and billing execution.