Search Results ozf_offer_adjustment_lines

Overview

The OZF_OFFER_ADJUSTMENT_LINES table is a core transactional data store within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the detailed line-level repository for discount and pricing adjustments associated with a trade promotion or offer. While the header table (OZF_OFFER_ADJUSTMENTS_B) defines the overall adjustment, this table stores the specific discount rules, amounts, or percentages that are applied to products, categories, or other qualifying entities. Its primary role is to enable the precise calculation and application of promotional offers, which is fundamental to trade fund management, accrual accounting, and claim settlement processes.

Key Information Stored

The table's structure is designed to capture the granular details of an offer adjustment. The primary key, OFFER_ADJUSTMENT_LINE_ID, uniquely identifies each discount line. A critical foreign key column, OFFER_ADJUSTMENT_ID, links each line to its parent adjustment header in the OZF_OFFER_ADJUSTMENTS_B table. While the provided ETRM metadata does not list all columns, typical data stored includes the adjustment type (e.g., percentage off, fixed amount), the qualifying product or category identifier, the adjustment value, applicable thresholds or limits, and sequencing information. Additional columns would track creation and last update dates, the creating user, and the object version number for data integrity.

Common Use Cases and Queries

This table is central to operations involving the analysis and validation of promotional discounts. Common use cases include generating reports on active discount lines for a specific product, auditing the total discount value of a promotion, and supporting the settlement of customer claims against trade funds. A typical query would join this table to its header and product tables to list all discount lines for a given offer.

SELECT h.offer_adjustment_number,
       l.offer_adjustment_line_id,
       l.discount_type_code,
       l.adjustment_value
FROM   ozf_offer_adjustment_lines l,
       ozf_offer_adjustments_b h
WHERE  l.offer_adjustment_id = h.offer_adjustment_id
AND    h.offer_adjustment_id = :p_adj_id;

Data from this table also feeds into key OZF reports such as Promotion Effectiveness and Trade Fund Liability analyses.

Related Objects

The OZF_OFFER_ADJUSTMENT_LINES table has a direct and essential relationship with the offer adjustment header. As documented in the provided metadata:

• OZF_OFFER_ADJUSTMENTS_B: This is the primary parent table. Each record in OZF_OFFER_ADJUSTMENT_LINES must reference a single, valid header record via the foreign key column OFFER_ADJUSTMENT_ID.

While not listed in the provided excerpt, this table is also a likely parent to other transactional tables in the OZF schema, such as those recording actual claim lines (OZF_CLAIM_LINES) or accrual details, where specific applied discounts are stored with a reference back to the original adjustment line that authorized them.