Search Results okc_price_adj_attribs_h




Overview
Explore in AI Chat

Overview

The table OKC_PRICE_ADJ_ATTRIBS_H is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module. It functions as a historical or versioning table, storing the specific attribute values that are directly tied to a price adjustment. In the context of contract management, price adjustments are modifications to the pricing terms of a contract line, such as discounts, surcharges, or formula-based changes. This table captures the detailed, attribute-level data that defines the basis or parameters of those adjustments, preserving a historical record of changes over time. Its role is critical for maintaining a complete audit trail of how contract pricing has been modified, ensuring compliance and enabling detailed analysis of pricing history.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary purpose is to store historical snapshots of price adjustment attributes. Based on its description and naming convention, key data points typically stored include a unique identifier (ID), a foreign key linking to the parent price adjustment (PAT_ID), and various columns representing the attribute names and their corresponding values at a point in time. These attributes could define the adjustment's calculation method, applicable thresholds, percentage or fixed amounts, and other qualifying conditions. The inclusion of "_H" in the table name strongly indicates it contains standard audit columns such as CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, and LAST_UPDATED_BY to track the history of each record.

Common Use Cases and Queries

This table is primarily accessed for historical reporting and audit purposes. Common use cases include generating reports to show the evolution of price adjustment terms for a specific contract line over its lifecycle, or analyzing pricing trends based on different adjustment attributes. Troubleshooting specific pricing outcomes on historical contracts also requires querying this table. A typical query pattern involves joining this table to its parent, OKC_PRICE_ADJUSTMENTS, to retrieve a comprehensive adjustment history.

  • Sample Query Pattern: SELECT h.* FROM okc_price_adj_attribs_h h, okc_price_adjustments pa WHERE h.pat_id = pa.id AND pa.line_id = :p_contract_line_id ORDER BY h.creation_date;
  • Reporting Use Case: Auditors may run queries against this table to verify that all price adjustments applied to a contract during a specific period had the correct attribute values as per the agreed commercial terms.

Related Objects

The table maintains a direct foreign key relationship with a core transactional table in the Contracts Core module, as documented in the provided metadata.

  • OKC_PRICE_ADJUSTMENTS: This is the primary parent table. The foreign key column OKC_PRICE_ADJ_ATTRIBS_H.PAT_ID references the primary key (likely ID) of the OKC_PRICE_ADJUSTMENTS table. Every historical attribute record in OKC_PRICE_ADJ_ATTRIBS_H is associated with a specific price adjustment record. This relationship is fundamental for tracing historical attribute data back to its originating adjustment.