Search Results object_class




Overview
Explore in AI Chat

Overview

The table OZF.OZF_ACTIVITY_CUSTOMERS is a transaction data table in the Oracle EBS 12.1.1 and 12.2.2 Oracle Trade Management (OZF) schema. Per the ETRM metadata, it stores the denormalized market eligibility for an Offer and a Campaign Schedule of type Deal or Trade Promotion. In practical terms, the table materializes the resolved intersection between marketing activities (offers, deals, trade promotions) and the customer hierarchy against which those activities are eligible to be executed. The denormalized design avoids repeated runtime evaluation of complex qualifier rules by persisting the outcome of eligibility resolution into rows keyed by activity and customer.

Using a heuristic Data Vault lens, the physical design of the table suggests a link classification. The presence of two non-unique secondary indexes bound to surrogate foreign keys (OBJECT_CLASS/OBJECT_ID and SITE_USE_ID) and the reference to HZ_PARTIES, HZ_CUST_ACCOUNTS, and HZ_CUST_ACCT_SITES_ALL is consistent with an associative structure capturing relationships between marketing activities and trading partners rather than a pure descriptive hub or a slowly changing satellite.

Key Information Stored

The table's surrogate primary key is ACTIVITY_CUSTOMER_ID, defined by the constraint OZF_ACTIVITY_CUSTOMERS_PK. Two secondary non-unique indexes provide the principal access paths: OZF_ACTIVITY_CUSTOMERS_N1 on (OBJECT_CLASS, OBJECT_ID) and OZF_ACTIVITY_CUSTOMERS_N2 on SITE_USE_ID. No documented unique business key exists beyond the surrogate, so business-key candidacy is expressed through the object and customer identifiers and the associated qualifier columns.

Common Use Cases and Queries

The table is the primary source for determining which customers are eligible for a given offer or promotion, and for reporting realized versus forecast performance by customer. Typical access patterns use the (OBJECT_CLASS, OBJECT_ID) index to retrieve all eligible customers for an activity, or the SITE_USE_ID index to retrieve all activities for a specific customer site use.

  • Eligibility lookup: SELECT * FROM OZF_ACTIVITY_CUSTOMERS WHERE OBJECT_CLASS = 'OFFER' AND OBJECT_ID = :offer_id AND ACTIVE_FLAG = 'Y';
  • Customer activity history: SELECT OBJECT_ID, OFFER_CODE, START_DATE, END_DATE FROM OZF_ACTIVITY_CUSTOMERS WHERE SITE_USE_ID = :site_use_id AND SYSDATE BETWEEN START_DATE AND END_DATE;
  • Performance rollup: aggregate ACTUAL_REVENUE and FORECAST_REVENUE grouped by ACTIVITY_ID and CURRENCY_CODE, typically restricted by PROD_INDICATOR to exclude non-production rows.
  • Qualifier-driven reporting: filter by QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE, and QP_QUALIFIER_GROUP to reproduce the eligibility rule set applied to each customer.

Related Objects

The ETRM relationship metadata documents foreign keys that anchor this table to the trading partner and marketing activity models. The principal related objects are:

  • OZF_OFFERS — referenced via OBJECT_ID, providing the offer definition that eligibility is resolved against.
  • HZ_PARTIES — referenced via HZ_PARTIES_PARTY_ID, supplying the trading partner identity.
  • HZ_CUST_ACCOUNTS — referenced via CUST_ACCOUNT_ID, providing the customer account.
  • HZ_CUST_ACCT_SITES_ALL — referenced via CUST_ACCT_SITE_ID, providing the customer account site.
  • AMS_CUSTOM_SETUPS_B — referenced via CUSTOM_SETUP_ID, linking the row to a defined custom setup.
  • OZF_ACTIVITY_CUSTOMERS_PK — the primary key constraint used by dependent objects and by the Oracle Trade Management application layer.