Search Results ozf_discount_product_reln




Overview
Explore in AI Chat

Overview

The OZF_DISCOUNT_PRODUCT_RELN table is a core data structure within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a relational junction table, specifically designed to manage and store the associations between discount lines and the products or product categories to which those discounts apply. Its primary role is to enforce the business rules governing which products are eligible for specific promotional offers or discounts defined in the system. By maintaining these relationships, the table is essential for the accurate calculation, validation, and application of trade promotions during order management and settlement processes.

Key Information Stored

The table's structure centers around foreign key relationships that link discount definitions to product definitions. The primary identifier for each relationship record is the DISCOUNT_PRODUCT_RELN_ID column, which is the table's primary key. Two critical foreign key columns define the core relationship: OFFER_DISCOUNT_LINE_ID links to the OZF_OFFER_DISCOUNT_LINES table, identifying the specific discount line or rule. The OFF_DISCOUNT_PRODUCT_ID links to the OZF_OFFER_DISCOUNT_PRODUCTS table, identifying the product, product category, or other product grouping that is subject to the discount. Additional columns typically track standard EBS audit information such as creation date, last update date, and the user responsible for the changes.

Common Use Cases and Queries

This table is central to queries that determine discount eligibility and analyze promotion coverage. A common operational use case is validating if a product on a sales order qualifies for an active promotion, which involves joining this table to discount header and line tables. For reporting, analysts frequently query this table to generate lists of all products included in a specific promotion or to audit the scope of a discount campaign. A sample SQL pattern to retrieve all products for a given discount line would be:

  • SELECT prod.product_code, prod.product_name
  • FROM ozf_discount_product_reln reln,
  • ozf_offer_discount_products prod
  • WHERE reln.off_discount_product_id = prod.off_discount_product_id
  • AND reln.offer_discount_line_id = <DISCOUNT_LINE_ID>;

Data integrity checks, such as identifying discount lines with no associated products, also rely on queries against this table.

Related Objects

As indicated by its foreign keys, OZF_DISCOUNT_PRODUCT_RELN has direct dependencies on two primary tables. It is a child table to OZF_OFFER_DISCOUNT_LINES, which holds the definition of the discount rules themselves (e.g., discount amount, type, dates). It is also a child table to OZF_OFFER_DISCOUNT_PRODUCTS, which serves as a master list of eligible products and product groupings defined within Trade Management. Consequently, this relationship table is a critical link in the data model between the discount rule engine (OZF_OFFER_DISCOUNT_LINES) and the product master data. Any processes, APIs, or user interfaces that create, update, or query discount product eligibility will interact with this table.