Search Results okc_price_adj_attribs




Overview
Explore in AI Chat

Overview

The OKC_PRICE_ADJ_ATTRIBS table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module. It serves as a child table that stores detailed attribute values associated with a specific price adjustment. In the context of contract management, price adjustments are used to modify the base price of a contract line based on predefined formulas, schedules, or conditions. This table provides the granular, attribute-level data that defines the parameters or values used within those adjustment calculations, enabling complex and configurable pricing logic within contractual agreements.

Key Information Stored

The table's primary function is to hold attribute-value pairs linked to a parent price adjustment. While the full column list is not detailed in the provided metadata, its structure is defined by its foreign key relationship and purpose. The documented primary key column, ID, uniquely identifies each attribute record. The critical foreign key column, PAT_ID, links each attribute record to its master price adjustment record in the OKC_PRICE_ADJUSTMENTS table. Other typical columns in such a structure would include fields to store the attribute name or code, the attribute value (which could be a number, date, or text), and potentially data type indicators or display sequence information. This design allows a single price adjustment to be governed by multiple, discrete attributes.

Common Use Cases and Queries

This table is primarily accessed for operational reporting, data validation, and troubleshooting within the pricing engine of Contracts. Common scenarios include auditing the complete set of parameters used for a specific price adjustment or generating reports on pricing rules across contracts. A typical query would join this table to its parent to analyze adjustment criteria.

  • Retrieving All Attributes for an Adjustment: SELECT * FROM okc.okc_price_adj_attribs WHERE pat_id = <adjustment_id>;
  • Reporting on Adjustment Parameters: SELECT pa.adjustment_number, pa.description, att.attribute_name, att.attribute_value FROM okc_price_adjustments pa, okc_price_adj_attribs att WHERE pa.id = att.pat_id;

Direct manipulation of this table via DML is strongly discouraged; data should be created, updated, or deleted using the standard Contracts Core APIs to maintain business rule integrity.

Related Objects

The table has a direct and documented foreign key relationship, making it a central component in the price adjustment data model.

  • OKC_PRICE_ADJUSTMENTS: This is the primary parent table. The foreign key OKC_PRICE_ADJ_ATTRIBS.PAT_ID references the primary key (presumably ID) of the OKC_PRICE_ADJUSTMENTS table. Every record in OKC_PRICE_ADJ_ATTRIBS must correspond to a valid master adjustment record. This is the most critical relationship for joins and data integrity.

Given its role, the table is also likely referenced by various OKC views, seed data validation scripts, and the core pricing engine APIs within the Contracts module, though these are not explicitly listed in the provided metadata.