Search Results effectivity




The GML.OP_PRCE_EFF table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Global Price Engine (GML) module, which manages pricing rules and effective pricing for products across different business scenarios. This table stores price effectivity details, defining the validity periods, conditions, and adjustments applied to pricing rules in Oracle Advanced Pricing. Below is a detailed breakdown of its purpose, structure, and key attributes.

Purpose of GML.OP_PRCE_EFF

The GML.OP_PRCE_EFF table serves as a repository for price effectivity rules, determining when and how pricing adjustments (e.g., discounts, surcharges, or promotions) are applied to transactions. It works in conjunction with other Oracle Advanced Pricing tables to enforce complex pricing strategies, such as tiered pricing, seasonal discounts, or customer-specific pricing agreements. The table ensures that pricing rules are activated or deactivated based on predefined criteria like dates, customer segments, or product categories.

Key Attributes

The table includes the following critical columns:

  • PRICE_EFFECTIVITY_ID: A unique identifier for each price effectivity rule.
  • PRICING_ATTR_GROUP_ID: Links to the pricing attribute group defining the scope of the rule (e.g., customer, product, or geography).
  • START_DATE and END_DATE: Define the active period for the pricing rule.
  • PRICE_TYPE_CODE: Specifies whether the rule applies to a base price, discount, or surcharge.
  • PRICE_FORMULA_ID: References the formula used to calculate the adjusted price.
  • STATUS: Indicates whether the rule is active, inactive, or pending approval.
  • CREATED_BY and LAST_UPDATED_BY: Audit columns tracking user modifications.

Integration with Oracle EBS Modules

The GML.OP_PRCE_EFF table integrates with several Oracle EBS modules:

  • Order Management (OM): Applies pricing rules during order entry to ensure accurate invoicing.
  • Accounts Receivable (AR): Validates pricing adjustments during billing.
  • Inventory (INV): Supports price overrides for inventory transactions.
  • Advanced Pricing (QP): Shares data with the Qualifier, Modifier, and Formula tables to evaluate pricing conditions.

Technical Considerations

In Oracle EBS 12.1.1 and 12.2.2, the table is part of the GML schema, which is specific to the Global Price Engine. Performance optimization is critical for large-scale implementations, as pricing rules are evaluated in real-time during transactions. Indexes on PRICE_EFFECTIVITY_ID, PRICING_ATTR_GROUP_ID, and date columns are recommended. Customizations or extensions to this table require careful testing to avoid conflicts with Oracle’s pricing engine logic.

Conclusion

The GML.OP_PRCE_EFF table is a foundational component of Oracle Advanced Pricing, enabling dynamic and context-aware pricing strategies. Its structure and relationships with other EBS modules ensure consistent pricing across sales, inventory, and financial processes. Proper configuration and maintenance of this table are essential for accurate pricing execution in Oracle EBS deployments.