Search Results ozf_offer_adjustments_b




Overview
Explore in AI Chat

Overview

The OZF_OFFER_ADJUSTMENTS_B table is a core data object within the Oracle Trade Management module (OZF) of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the primary transactional repository for all adjustments associated with a trade promotion or marketing offer. An adjustment represents a modification to the standard pricing or terms of an offer, such as a discount, a charge, or a promotional benefit applied to a sales transaction. This table is fundamental to the system's ability to calculate and manage complex promotional pricing and settlement processes, linking high-level offer definitions to the specific adjustment lines and tiers that define the calculation logic.

Key Information Stored

As a base table, OZF_OFFER_ADJUSTMENTS_B stores the essential header-level attributes for an adjustment. The primary key, OFFER_ADJUSTMENT_ID, uniquely identifies each adjustment record. A critical foreign key column is LIST_HEADER_ID, which links the adjustment to its parent offer in the OZF_OFFERS table. While the full column list is not detailed in the provided metadata, typical columns in such a structure would include fields to define the adjustment type (e.g., discount, surcharge), status, effective dates, currency, and associated calculation rules. The table acts as the anchor point for multilingual descriptive data stored in the related OZF_OFFER_ADJUSTMENTS_TL (Translation) table.

Common Use Cases and Queries

This table is central to queries involving the analysis and auditing of promotional offers. Common use cases include generating reports on all adjustments for a specific offer, validating adjustment setups during the offer creation process, and supporting the calculation engine during order entry and claims settlement. A typical reporting query would join this table to its parent offer and child lines to summarize adjustment details.

Sample Query Pattern:
SELECT ozf_offers.offer_number,
ozf_offer_adjustments_b.offer_adjustment_id,
ozf_offer_adjustment_lines.adjusted_amount
FROM ozf_offer_adjustments_b
JOIN ozf_offers ON ozf_offer_adjustments_b.list_header_id = ozf_offers.list_header_id
JOIN ozf_offer_adjustment_lines ON ozf_offer_adjustments_b.offer_adjustment_id = ozf_offer_adjustment_lines.offer_adjustment_id
WHERE ozf_offers.offer_id = :p_offer_id;

Related Objects

The OZF_OFFER_ADJUSTMENTS_B table is a key hub within the Trade Management schema, with documented relationships to several critical objects:

  • Parent Table: OZF_OFFERS, joined via OZF_OFFER_ADJUSTMENTS_B.LIST_HEADER_ID.
  • Child Tables:
    • OZF_OFFER_ADJUSTMENTS_TL (Translation), joined via OZF_OFFER_ADJUSTMENTS_TL.OFFER_ADJUSTMENT_ID.
    • OZF_OFFER_ADJUSTMENT_LINES, joined via OZF_OFFER_ADJUSTMENT_LINES.OFFER_ADJUSTMENT_ID.
    • OZF_OFFER_ADJUSTMENT_TIERS, joined via OZF_OFFER_ADJUSTMENT_TIERS.OFFER_ADJUSTMENT_ID.

These relationships create a hierarchical data model where an Offer contains one or more Offer Adjustments, each of which can have multiple descriptive translations, detailed lines, and pricing tiers.