Results for “automatic_discount_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SO_DISCOUNTS is a foundational table in the Oracle E-Business Suite (EBS) Order Entry (OE) module, residing in the OE schema. It stores the master discount definitions that drive price adjustments across pricing, quoting, and order management flows. Each row represents a named discount — qualifying customers and items, then applying either a percentage or an absolute amount off the list price. Its persistent role as the foreign-key target for price adjustments and discount qualifications makes it the anchor of the discount configuration model in both 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined FK structure suggests SO_DISCOUNTS is hub-leaning: its primary key DISCOUNT_ID is a stable business key referenced by many dependent tables, while descriptive columns such as NAME, PERCENT, and AMOUNT behave satellite-like. Analysts designing a warehouse should treat DISCOUNT_ID as a hub key and separate the descriptive and foreign-key narrative into satellites and links.

Key Information Stored

The table contains 40 documented columns. The most operationally significant are:

• DISCOUNT_ID — surrogate primary key (SO_DISCOUNTS_PK, unique index SO_DISCOUNTS_U1); the identifier used in every referencing table.
• NAME — human-readable discount name; combined with PRICE_LIST_ID it forms the business key (SO_DISCOUNTS_U2), enforcing unique discount names per price list.
• PRICE_LIST_ID — foreign key to SO_PRICE_LISTS_B, scoping the discount to a price list.
• DISCOUNT_TYPE_CODE — classifies the discount type and drives qualification logic.
• PERCENT and AMOUNT — the two possible value forms of the price reduction.
• AUTOMATIC_DISCOUNT_FLAG, MANUAL_PRICING_DISCOUNT_FLAG, OVERRIDE_ALLOWED_FLAG, and PRORATE_FLAG — control application behavior and whether users may override.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the active date window governing eligibility.
• GSA_INDICATOR — flags GSA-specific pricing applicability.
• DISCOUNT_LINES_FLAG — indicates whether line-level qualifications exist.
• DESCRIPTION — free-form text for the discount.
• CONTEXT and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) container.
• Standard WHO/audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and concurrent program columns (PROGRAM_ID, PROGRAM_APPLICATION_ID, REQUEST_ID) — track change history and batch processing.

Common Use Cases and Queries

Typical usage centers on reviewing active discount definitions, auditing pricing configuration, and reconciling applied adjustments back to their source. Common patterns include:

• Listing currently active discounts on a price list:

  SELECT discount_id, name, discount_type_code, percent, amount
  FROM   oe.so_discounts
  WHERE  price_list_id = :p_price_list_id
  AND    TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

• Identifying automatic versus manually applied discounts:

  SELECT name, automatic_discount_flag, manual_pricing_discount_flag, override_allowed_flag
  FROM   oe.so_discounts
  WHERE  automatic_discount_flag = 'Y';

• Auditing created/updated discounts by concurrent request for troubleshooting:

  SELECT discount_id, name, request_id, last_update_date, last_updated_by
  FROM   oe.so_discounts
  ORDER  BY last_update_date DESC;

• Reporting with price list context via join to SO_PRICE_LISTS_B on price_list_id.

These queries support pricing configuration reviews, discount effectiveness reporting, and post-implementation validation.

Related Objects

SO_DISCOUNTS participates in a broad relationship graph. The most significant dependents and references are:

• SO_PRICE_LISTS_B — referenced by SO_DISCOUNTS.PRICE_LIST_ID; defines the price list a discount belongs to.
• SO_PRICE_ADJUSTMENTS — references DISCOUNT_ID; records the adjustments actually applied to orders.
• SO_PRICE_ADJUSTMENTS_INTERFACE — references DISCOUNT_ID; the inbound interface for adjustments.
• SO_DISCOUNT_CUSTOMERS — references DISCOUNT_ID; qualifies which customers receive the discount.
• SO_DISCOUNT_LINES_115 — references DISCOUNT_ID; historical line-level discount qualifications.
• OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJS_HISTORY — reference DISCOUNT_ID for applied and historical adjustments.
• OE_PRICING_CONTRACTS — references DISCOUNT_ID for contract-based pricing.
• AS_QUOTES_ALL and AS_QUOTE_LINES_ALL — reference DISCOUNT_ID in the quoting module.
• OE_PRICE_ADJS_IFACE_ALL and OKS_COV_TXN_GROUPS_INT_ALL — additional interface consumers referencing the discount key.

Collectively these relationships confirm SO_DISCOUNTS as the central hub for discount definitions underpinning pricing, quoting, and service contract flows in Oracle EBS.