Search Results so_discounts




Overview
Explore in AI Chat

Overview

The SO_DISCOUNTS table is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module. It serves as the master repository for defining discount rules that can be applied to sales orders for price adjustments. Its primary role is to store the definition and control parameters for discounts, which are then referenced during order pricing and invoicing processes to calculate final line or header-level price reductions. This table is integral to the pricing engine, enabling businesses to implement complex discounting strategies based on various criteria.

Key Information Stored

The table's structure is centered around a unique discount identifier and its association with a specific price list. Based on the documented primary and unique keys, the most critical columns are:

  • DISCOUNT_ID: The primary key (PK) and unique identifier for each discount record.
  • PRICE_LIST_ID: A foreign key linking the discount to a specific price list defined in the SO_PRICE_LISTS_B table. The combination of PRICE_LIST_ID and NAME forms a unique constraint (UK1), ensuring discount names are unique within a price list.
  • NAME: The descriptive name of the discount as it appears within the application.

While the provided metadata does not list all columns, typical supplementary data in this table would include attributes such as discount type (percentage, fixed amount), start and end dates, calculation precedence, and activation status.

Common Use Cases and Queries

This table is central to pricing operations. A common use case is retrieving all active discounts available for a specific price list to display in a pricing engine or customer-facing application. For reporting, analysts often query this table to audit discount definitions and their usage. A typical SQL pattern involves joining with the price lists table and filtering by date and status.

SELECT d.name, d.discount_id, pl.name price_list
FROM oe.so_discounts d,
     oe.so_price_lists_b pl
WHERE d.price_list_id = pl.price_list_id
AND SYSDATE BETWEEN d.start_date_active AND NVL(d.end_date_active, SYSDATE)
AND d.enabled_flag = 'Y';

Another critical use case is troubleshooting order pricing by tracing which discount rule (from SO_DISCOUNTS) was applied to a specific price adjustment recorded in the SO_PRICE_ADJUSTMENTS table.

Related Objects

The SO_DISCOUNTS table has defined relationships with several key transactional and setup tables in the Order Entry module, as documented by its foreign key constraints:

  • SO_PRICE_LISTS_B: The parent table. A discount is defined for a specific price list via SO_DISCOUNTS.PRICE_LIST_ID.
  • SO_DISCOUNT_CUSTOMERS: Stores customer-specific eligibility or overrides for discounts, linked by DISCOUNT_ID.
  • SO_DISCOUNT_LINES_115: Likely holds detailed discount rules or qualifying conditions, linked by DISCOUNT_ID.
  • SO_PRICE_ADJUSTMENTS: The primary transactional child table. Records the actual application of a discount to an order line, linked by DISCOUNT_ID.
  • SO_PRICE_ADJUSTMENTS_INTERFACE: Used for importing price adjustments, linked by DISCOUNT_ID.

These relationships underscore the table's position as a master definition, referenced throughout the discount setup, application, and transaction lifecycle.