Results for “ozf_offer_qualifiers”

50+ results




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

Overview

OZF_OFFER_QUALIFIERS is a Trade Management (OZF) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the market eligibility criteria for Trade Management Offers. Each row defines a qualifier — a condition that determines whether a given offer is applicable to a particular market, customer segment, product set, or other targeting dimension. Offers are only surfaced to the trade channel when their associated qualifier rows evaluate true, making this table central to offer targeting and eligibility logic.

From a Data Vault modeling perspective, the FK structure (OFFER_ID → OZF_OFFERS and OFFER_DISCOUNT_LINE_ID → OZF_OFFER_DISCOUNT_LINES) suggests this object is satellite-leaning: it holds descriptive, versionable attributes attached to parent Offer and Offer Discount Line hubs/links rather than representing an independent business entity. The qualifier grouping and context/attribute columns reinforce this descriptive, dependent nature.

Key Information Stored

The table contains 32 columns. The most operationally significant include:

Common Use Cases and Queries

Typical scenarios include resolving which offers apply to a given customer or product, auditing qualifier configuration on a promotion, and validating effective-dated eligibility windows. A representative query retrieves active qualifiers for a specific offer:

  • SELECT q.qualifier_id, q.qualifier_grouping_no, q.qualifier_context, q.qualifier_attribute, q.qualifier_attr_value, q.start_date_active, q.end_date_active FROM ozf_offer_qualifiers q WHERE q.offer_id = :offer_id AND q.active_flag = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(q.start_date_active, SYSDATE) AND NVL(q.end_date_active, SYSDATE + 1);
  • Join to OZF_OFFERS to report offer name alongside each qualifier for promoter configuration reviews.
  • Join to OZF_OFFER_DISCOUNT_LINES to determine line-level eligibility for discount calculations.
  • Group by QUALIFIER_GROUPING_NO to reconstruct the logical AND/OR structure of a promotion's targeting rules.

Reporting uses include promotion effectiveness analysis, gap checks for offers lacking qualifiers, and migration validation when moving offer configurations between environments.

Related Objects

  • OZF_OFFERS — parent offer master; join on OFFER_ID.
  • OZF_OFFER_DISCOUNT_LINES — line-level discounts; join on OFFER_DISCOUNT_LINE_ID.
  • OZF_OFFER_QUALIFIERS_PK / OZF_OFFER_QUALIFIERS_U1 — primary key and unique index on QUALIFIER_ID.
  • Related OZF tables such as OZF_OFFER_ELIGIBILITY and OZF_OFFER_HEADERS commonly referenced in offer configuration, along with the OZF public APIs used to import and validate offer definitions.