Results for “ozf_worksheet_qualifiers”

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

Overview

OZF_WORKSHEET_QUALIFIERS is a Trade Management (OZF) table that stores the market eligibility criteria associated with an Offer Worksheet. In Oracle EBS Trade Management, worksheets are used to plan, define, and qualify promotions, offers, and trade deals. The qualifiers held in this table determine the market segments, customers, or attribute conditions against which a worksheet is evaluated for eligibility. Because it records the qualification rules that control how offers are applied, this object is central to offer targeting logic within the Trade Management module.

The table resides in the OZF schema and is valid in both 12.1.1 and 12.2.2. Its primary key is defined by the index OZF_WORKSHEET_QUALIFIERS_PK on WORKSHEET_QUALIFIER_ID, and a unique index OZF_WORKSHEET_QUALIFIERS_U1 covers the same column. A single foreign key links WORKSHEET_HEADER_ID to OZF_WORKSHEET_HEADERS_B, tying each qualifier row to its parent worksheet. Several WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) plus OBJECT_VERSION_NUMBER indicate the table participates in Oracle's standard concurrent and locking framework.

From a dimensional modeling perspective, the mined foreign-key structure classifies this table as satellite-leaning. It should be treated as a candidate satellite hanging off the worksheet header hub, since it carries descriptive, worksheet-dependent qualification attributes rather than functioning as an independent entity or a many-to-many resolution link.

Key Information Stored

The most significant columns, drawn from the documented metadata, are:

• WORKSHEET_QUALIFIER_ID — Surrogate primary key generated for each qualifier line; defined as the business-key candidate via OZF_WORKSHEET_QUALIFIERS_U1.
• WORKSHEET_HEADER_ID — Foreign key to OZF_WORKSHEET_HEADERS_B, identifying the parent worksheet.
• QUALIFIER_GROUPING_NO — Groups multiple qualifier rows into a single logical eligibility set.
• QUALIFIER_CONTEXT — The context (e.g., a descriptive flexfield or attribute context) in which the qualifier attribute is defined.
• QUALIFIER_ATTRIBUTE — The attribute name being qualified within the worksheet.
• QUALIFIER_ATTR_VALUE — The value the attribute is compared against.
• QUALIFIER_CONCAT_VALUE — A concatenated representation of qualifier values, useful for display and matching.
• COMPARISON_OPERATOR_CODE — The operator (=, <, >, between, etc.) used in the qualification test.
• QUAL_ATTR_VALUE_FROM_NUMBER / QUAL_ATTR_VALUE_TO_NUMBER — Numeric range boundaries supporting range-based qualifiers.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Effective dating for the qualifier's validity window.
• Standard WHO and version columns track audit and concurrency.

Common Use Cases and Queries

Typical usage includes retrieving all qualifiers for a worksheet, listing active qualifiers for a given date, and reporting which offers are eligible for a market or customer segment.

• All qualifiers for a worksheet: SELECT * FROM ozf.ozf_worksheet_qualifiers WHERE worksheet_header_id = :header_id;
• Active qualifiers only: add AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
• Grouped eligibility logic: SELECT qualifier_grouping_no, qualifier_attribute, comparison_operator_code, qualifier_attr_value FROM ozf.ozf_worksheet_qualifiers ORDER BY worksheet_header_id, qualifier_grouping_no;
• Range qualifiers: filter on qual_attr_value_from_number and qual_attr_value_to_number where comparison_operator_code denotes a range.

Related Objects

• OZF_WORKSHEET_HEADERS_B — Parent table; join on OZF_WORKSHEET_QUALIFIERS.WORKSHEET_HEADER_ID = OZF_WORKSHEET_HEADERS_B.WORKSHEET_HEADER_ID.
• OZF_WORKSHEET_HEADERS_TL — Provides translated worksheet names.
• OZF offer and promotion tables associated with the worksheet for eligibility evaluation.
• Trade Management qualification APIs and concurrent programs that consume worksheet qualifiers.
• Standard OZF lookup views resolving COMPARISON_OPERATOR_CODE.