Search Results pricing_rule_id




Overview
Explore in AI Chat

Overview

The SO_PRICING_RULES_B table is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically for releases 12.1.1 and 12.2.2. It serves as the master definition table for pricing rules, which are fundamental components of the Advanced Pricing engine. These rules govern how prices, discounts, surcharges, and promotions are applied to sales orders and quotations. The table stores the header-level attributes of a pricing rule, which can be linked to price lists or specific item groups to create complex, conditional pricing strategies. Its role is central to ensuring accurate and automated price calculations based on predefined business logic.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key and its relationships define its critical structure. The primary identifier is the PRICING_RULE_ID column, which uniquely defines each pricing rule header. Based on its function, the table typically stores descriptive and control information for a rule. Common columns in such a header table include the RULE_NAME, a DESCRIPTION, effective dates (START_DATE_ACTIVE, END_DATE_ACTIVE), and a base pricing attribute such as a DISCOUNT or ADJUSTMENT_AMOUNT. It also contains control columns like CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE for auditing, along with an ENABLED_FLAG to control the rule's active status.

Common Use Cases and Queries

This table is primarily accessed for pricing setup, troubleshooting, and reporting. Administrators query it to audit active pricing rules or to identify rules applied during specific order transactions. A common reporting use case involves joining this table to its related lines table to get a complete view of a rule's conditions and adjustments. For instance, to list all active pricing rules, a query might be: SELECT pricing_rule_id, rule_name, description FROM oe.so_pricing_rules_b WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) AND enabled_flag = 'Y';. Technical consultants often trace from an order line's price adjustment back to this table to validate pricing logic or diagnose incorrect charge calculations by joining through SO_PRICING_RULE_LINES.

Related Objects

The SO_PRICING_RULES_B table has a central relationship with several key transactional tables, as documented by its foreign keys. Its primary key (PRICING_RULE_ID) is referenced by the following objects:

  • SO_PRICING_RULE_LINES: This is the most direct relationship. The PRICING_RULE_ID in SO_PRICING_RULE_LINES links to this header table, storing the detailed conditions, qualifiers, and adjustment formulas that define the rule's execution logic.
  • SO_PRICE_LIST_LINES_115: The PRICING_RULE_ID in this table links a pricing rule directly to a specific line on a price list, allowing for list-line-specific pricing overrides or modifiers.
  • SO_ITEM_GROUP_LINES: The PRICING_RULE_ID in this table associates a pricing rule with an item group, enabling pricing strategies that apply to a defined collection of items rather than individual products.
These relationships illustrate that SO_PRICING_RULES_B acts as a shared master definition, enabling its rules to be invoked from multiple pricing contexts within the Order Management ecosystem.