Search Results price
The OKC_PRICE_ADJ_ATTRIBS_H table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Oracle Contracts Core module, specifically designed to store historical attribute information related to price adjustments. This table plays a pivotal role in maintaining an auditable trail of changes made to price adjustment attributes over time, ensuring compliance, traceability, and accurate financial reporting. Below is a detailed analysis of its purpose, structure, and functional relevance in Oracle EBS.
Purpose and Functional Context
The OKC_PRICE_ADJ_ATTRIBS_H table is part of the Oracle Contracts Core tables, which support the management of complex contractual agreements, including pricing terms, adjustments, and amendments. Price adjustments are often applied to contracts to account for variables such as inflation, volume discounts, or market fluctuations. This table captures historical snapshots of attribute changes tied to these adjustments, enabling users to track modifications, analyze trends, and resolve disputes by referencing past states of contract terms.Table Structure and Key Columns
The table's schema includes columns that store metadata about price adjustment attributes, their historical values, and audit information. Key columns typically include:- ID: A unique identifier for the historical record, often a surrogate key.
- PRICE_ADJUSTMENT_ID: References the parent price adjustment record in the OKC_PRICE_ADJUSTMENTS table.
- ATTRIBUTE_NAME: The name of the attribute being modified (e.g., discount percentage, fixed amount).
- OLD_VALUE and NEW_VALUE: Capture the previous and updated values of the attribute.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Standard Oracle audit columns to track who made the change and when.
- CHANGE_REASON: Optional field to document the rationale for the adjustment.
Integration with Other Modules
The OKC_PRICE_ADJ_ATTRIBS_H table integrates with several Oracle EBS modules:- Oracle Advanced Pricing: Links to pricing rules and modifiers applied to contracts.
- Oracle Receivables: Ensures invoicing reflects the correct historical pricing terms.
- Oracle General Ledger: Supports financial reporting by providing a traceable record of revenue-impacting changes.
Business Process Implications
This table is essential for:- Audit Compliance: Meets regulatory requirements by preserving a tamper-evident history of pricing changes.
- Dispute Resolution: Allows parties to review past adjustments to resolve billing disagreements.
- Trend Analysis: Enables businesses to analyze how pricing strategies evolve over time.
Technical Considerations
In Oracle EBS 12.1.1 and 12.2.2, the table is typically accessed via APIs or standard Oracle Forms. Custom reports or extensions should leverage the OKC public APIs to ensure data integrity. Partitioning or indexing strategies may be applied to optimize performance for large datasets.Conclusion
The OKC_PRICE_ADJ_ATTRIBS_H table is a foundational component of Oracle Contracts Core, providing a robust mechanism to track and audit price adjustment attributes. Its design aligns with Oracle EBS's emphasis on compliance, financial accuracy, and operational transparency, making it indispensable for organizations managing complex contractual agreements.-
Lookup Type: OKC_PH_LINE_PRICE_TYPE
12.1.1
product: OKC - Contracts Core , meaning: Price Hold Line Price Type , description: Price Hold Line Price Type ,
-
Lookup Type: OKC_PH_LINE_PRICE_TYPE
12.2.2
product: OKC - Contracts Core , meaning: Price Hold Line Price Type , description: Price Hold Line Price Type ,
-
Lookup Type: OKC_PH_PRICE_TYPE
12.1.1
product: OKC - Contracts Core , meaning: Price Hold Price type , description: Price Hold Price type ,
-
Lookup Type: OKC_PH_PRICE_TYPE
12.2.2
product: OKC - Contracts Core , meaning: Price Hold Price type , description: Price Hold Price type ,
-
Lookup Type: OKC_PH_PRICE_BREAK_BASIS
12.1.1
product: OKC - Contracts Core , meaning: Price Break Basis , description: Price Break Basis ,
-
Table: OKC_PRICE_ADJ_ATTRIBS_H
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ADJ_ATTRIBS_H, object_name:OKC_PRICE_ADJ_ATTRIBS_H, status:VALID, product: OKC - Contracts Core , description: Price attribute values which are based on a price adjustment. , implementation_dba_data: OKC.OKC_PRICE_ADJ_ATTRIBS_H ,
-
Lookup Type: OKC_RENEWAL_PRICING_TYPE
12.1.1
product: OKC - Contracts Core , meaning: Renewal Pricing Types , description: Types of pricing for renewed contract ,
-
Lookup Type: OKC_PH_PRICE_BREAK_BASIS
12.2.2
product: OKC - Contracts Core , meaning: Price Break Basis , description: Price Break Basis ,
-
Table: OKC_PRICE_ADJ_ASSOCS_H
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS_H, object_name:OKC_PRICE_ADJ_ASSOCS_H, status:VALID, product: OKC - Contracts Core , description: Associates price adjustments to the object for which price has been adjusted. , implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS_H ,
-
Lookup Type: OKC_RENEWAL_PRICING_TYPE
12.2.2
product: OKC - Contracts Core , meaning: Renewal Pricing Types , description: Types of pricing for renewed contract ,
-
Table: OKC_PRICE_ADJ_ATTRIBS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ADJ_ATTRIBS, object_name:OKC_PRICE_ADJ_ATTRIBS, status:VALID, product: OKC - Contracts Core , description: Price attribute values which are based on a price adjustment. , implementation_dba_data: OKC.OKC_PRICE_ADJ_ATTRIBS ,
-
Table: OKC_PRICE_ADJ_ATTRIBS
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ADJ_ATTRIBS, object_name:OKC_PRICE_ADJ_ATTRIBS, status:VALID, product: OKC - Contracts Core , description: Price attribute values which are based on a price adjustment. , implementation_dba_data: OKC.OKC_PRICE_ADJ_ATTRIBS ,
-
Table: OKC_PRICE_ADJUSTMENTS_H
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ADJUSTMENTS_H, object_name:OKC_PRICE_ADJUSTMENTS_H, status:VALID, product: OKC - Contracts Core , description: Record of actual adjustments made to price based on price attribute values. , implementation_dba_data: OKC.OKC_PRICE_ADJUSTMENTS_H ,
-
Table: OKC_PRICE_ADJ_ASSOCS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS, object_name:OKC_PRICE_ADJ_ASSOCS, status:VALID, product: OKC - Contracts Core , description: Associates price adjustments to the object for which price has been adjusted. , implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS ,
-
Table: OKC_PRICE_ATT_VALUES_H
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ATT_VALUES_H, object_name:OKC_PRICE_ATT_VALUES_H, status:VALID, product: OKC - Contracts Core , description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. , implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES_H ,
-
Table: OKC_PRICE_ATT_VALUES
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ATT_VALUES, object_name:OKC_PRICE_ATT_VALUES, status:VALID, product: OKC - Contracts Core , description: Values of price attributes for an object to be used to derive the price for a contract header and contract line , implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES ,
-
Table: OKC_PRICE_ADJ_ASSOCS
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS, object_name:OKC_PRICE_ADJ_ASSOCS, status:VALID, product: OKC - Contracts Core , description: Associates price adjustments to the object for which price has been adjusted. , implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS ,
-
Table: OKC_PRICE_ATT_VALUES_H
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ATT_VALUES_H, object_name:OKC_PRICE_ATT_VALUES_H, status:VALID, product: OKC - Contracts Core , description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. , implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES_H ,
-
Table: OKC_PRICE_ATT_VALUES
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ATT_VALUES, object_name:OKC_PRICE_ATT_VALUES, status:VALID, product: OKC - Contracts Core , description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. , implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES ,
-
Table: OKC_PRICE_ADJUSTMENTS
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ADJUSTMENTS, object_name:OKC_PRICE_ADJUSTMENTS, status:VALID, product: OKC - Contracts Core , description: Record of actual adjustments made to price based on price attribute values. , implementation_dba_data: OKC.OKC_PRICE_ADJUSTMENTS ,
-
Table: OKC_PRICE_ADJUSTMENTS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PRICE_ADJUSTMENTS, object_name:OKC_PRICE_ADJUSTMENTS, status:VALID, product: OKC - Contracts Core , description: Record of actual adjustments made to price based on price attribute values. , implementation_dba_data: OKC.OKC_PRICE_ADJUSTMENTS ,
-
Lookup Type: OKC_REP_SBCR_REC_SET_ASIDE
12.2.2
product: OKC - Contracts Core , meaning: SBCR Recommendations for Set Aside , description: SBCR Recommendations for Set Aside ,
-
Lookup Type: OKC_REP_SBCR_ACQ_SET_ASIDE
12.2.2
product: OKC - Contracts Core , meaning: SBCR Set Aside Acquisition History , description: SBCR Set Aside Acquisition History ,
-
Lookup Type: OKC_PRICE_TYPE
12.2.2
product: OKC - Contracts Core , meaning: Contracts Price type ,
-
Lookup Type: OKC_PRICE_TYPE
12.1.1
product: OKC - Contracts Core , meaning: Contracts Price type ,
-
Table: OKC_PH_LINE_BREAKS_H
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PH_LINE_BREAKS_H, object_name:OKC_PH_LINE_BREAKS_H, status:VALID, product: OKC - Contracts Core , description: This history table will store the information about line breaks on a price hold - Not Used , implementation_dba_data: OKC.OKC_PH_LINE_BREAKS_H ,
-
Table: OKC_PH_LINE_BREAKS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PH_LINE_BREAKS, object_name:OKC_PH_LINE_BREAKS, status:VALID, product: OKC - Contracts Core , description: This table will store the information about line breaks on a price hold - Not Used , implementation_dba_data: OKC.OKC_PH_LINE_BREAKS ,
-
Table: OKC_PH_LINE_BREAKS
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_PH_LINE_BREAKS, object_name:OKC_PH_LINE_BREAKS, status:VALID, product: OKC - Contracts Core , description: This table will store the information about line breaks on a price hold - Not Used , implementation_dba_data: OKC.OKC_PH_LINE_BREAKS ,
-
Table: OKC_K_LINES_B
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_K_LINES_B, object_name:OKC_K_LINES_B, status:VALID, product: OKC - Contracts Core , description: Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification. , implementation_dba_data: OKC.OKC_K_LINES_B ,
-
Table: OKC_K_LINES_B
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_K_LINES_B, object_name:OKC_K_LINES_B, status:VALID, product: OKC - Contracts Core , description: Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification. , implementation_dba_data: OKC.OKC_K_LINES_B ,
-
Lookup Type: OKC_RULE_GROUP_DEF
12.2.2
product: OKC - Contracts Core , meaning: Rule Group Defs , description: Place holder for all Rules to be assigned to a Contract ,
-
Lookup Type: OKC_RULE_GROUP_DEF
12.1.1
product: OKC - Contracts Core , meaning: Rule Group Defs , description: Place holder for all Rules to be assigned to a Contract ,