Search Results ozf_worksheet_qualifiers




Overview
Explore in AI Chat

Overview

The OZF_WORKSHEET_QUALIFIERS table is a core transactional data object within the Oracle E-Business Suite (EBS) Trade Management module (OZF). It serves the critical function of storing market eligibility rules for offer worksheets. In the context of trade promotions and funds management, an offer worksheet defines a specific promotional deal. This table qualifies which markets, such as specific customer segments, geographic regions, or product hierarchies, are eligible to participate in the offer. Its role is to enforce the business rules governing the applicability of a promotion, ensuring that discounts, accruals, and claims are processed only for the intended participants as defined during the worksheet setup.

Key Information Stored

The table's primary purpose is to link an offer worksheet to its qualifying criteria. The most significant columns, as indicated by the provided metadata, are the foreign key to the worksheet header and the primary key for the qualifier record itself. While the full column list is not detailed, the structure typically includes identifiers for the worksheet, the type of qualification (e.g., customer, product, geography), and references to the specific qualifying values. The primary key, WORKSHEET_QUALIFIER_ID, uniquely identifies each market eligibility rule. The foreign key column, WORKSHEET_HEADER_ID, is the critical link that associates all qualifier records with their parent offer worksheet in the OZF_WORKSHEET_HEADERS_B table.

Common Use Cases and Queries

This table is central to reporting and validation processes. A common use case is generating a list of all eligible markets for a specific promotion to validate targeting before launch. Another is during the claims settlement process, where a system check against this table confirms if a claiming transaction falls within a qualified market. For auditing, queries often join to the headers table to analyze promotion coverage. A fundamental SQL pattern retrieves all qualifiers for a given worksheet:

  • SELECT * FROM ozf.ozf_worksheet_qualifiers WHERE worksheet_header_id = <header_id>;

For integrated reporting, a join to the parent worksheet header is essential to include promotion details like name and status:

  • SELECT q.*, h.name FROM ozf.ozf_worksheet_qualifiers q, ozf.ozf_worksheet_headers_b h WHERE q.worksheet_header_id = h.worksheet_header_id;

Related Objects

The metadata explicitly documents a single, crucial foreign key relationship, establishing this table's dependency within the OZF schema. The OZF_WORKSHEET_QUALIFIERS table is a child of the OZF_WORKSHEET_HEADERS_B table. The relationship is maintained through the column OZF_WORKSHEET_QUALIFIERS.WORKSHEET_HEADER_ID, which references the primary key in OZF_WORKSHEET_HEADERS_B. This means every record in OZF_WORKSHEET_QUALIFIERS must correspond to a valid parent offer worksheet. No other foreign keys are documented in the provided excerpt, suggesting this table primarily serves as a detail table for the worksheet header, with other potential relationships possibly managed through the qualifying value identifiers not listed.