Search Results ozf_offer_performances




Overview
Explore in AI Chat

Overview

The OZF_OFFER_PERFORMANCES table is a core transactional data object within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the primary repository for storing performance rules associated with promotional offers. In the context of trade promotions, a performance rule defines the specific conditions or metrics that must be met for an offer to be considered successfully fulfilled. This table is integral to the offer management lifecycle, enabling the system to track, measure, and enforce the contractual performance criteria linked to trade deals and promotions, thereby supporting key processes like claim validation and funds management.

Key Information Stored

The central column in this table is OFFER_PERFORMANCE_ID, which serves as the unique primary key identifier for each performance rule record. A critical relational column is USED_BY_ID, which functions as a foreign key to link the performance rule to its parent object. While the provided metadata does not list all columns, typical data stored in such a table would include details defining the performance metric (e.g., sales volume target, growth percentage), the measurement period, the applicable product or geography, and the consequences of meeting or missing the target. Status and creation metadata are also standard.

Common Use Cases and Queries

The primary use case is the validation of promotional claims against pre-defined performance criteria. When a claim is submitted, the system queries this table to retrieve the performance rules for the associated offer to determine eligibility for payment. Common reporting queries involve analyzing offer performance adherence. A fundamental SQL pattern retrieves all performance rules for a specific offer, joining via the USED_BY_ID column:

  • SELECT * FROM ozf_offer_performances perf WHERE perf.used_by_id = :p_offer_id;

Another critical query supports audit and reconciliation reports by listing performance rules alongside their parent offer details, requiring a join to OZF_OFFERS.

Related Objects

The OZF_OFFER_PERFORMANCES table maintains defined foreign key relationships with two key transactional tables, both linked through the USED_BY_ID column. This indicates that performance rules can be associated with different types of parent entities within Trade Management.

  • OZF_OFFERS: This is the primary relationship, linking a performance rule directly to a trade promotion offer (OZF_OFFER_PERFORMANCES.USED_BY_ID -> OZF_OFFERS).
  • OZF_WORKSHEET_HEADERS_B: This relationship links a performance rule to a worksheet header, which is often used for planning and budgeting purposes within the module (OZF_OFFER_PERFORMANCES.USED_BY_ID -> OZF_WORKSHEET_HEADERS_B).

The table's primary key constraint is OZF_OFFER_PERFORMANCES_PK on the OFFER_PERFORMANCE_ID column.