Results for “product_context”

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

Overview

OZF_OFFER_ADJUSTMENT_PRODUCTS is a Trade Management (OZF) transaction table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the product-level information associated with an offer adjustment. Within the Trade Management module, offers and offer adjustments represent promotional rebates, discounts, and accrual terms negotiated with customers and suppliers. While the parent adjustment record defines the financial and eligibility rules of a promotion, this table determines precisely which inventory items participate in that adjustment and how each item is treated.

The table is owned by the OZF schema and is documented as VALID, containing 17 columns in the 12.2.2 physical schema. ETRM classifies it heuristically as a standalone object in a Data Vault sense; from a modeling perspective this suggests it behaves more like a satellite (or a self-contained hub-like entity referenced by external keys) rather than a central hub or a transaction link between two major business entities. Its granularity is one row per product/qualifier combination tied to an adjustment, and its data is transactional and auditable rather than reference/static.

Key Information Stored

The primary key is the surrogate column OFFER_ADJUSTMENT_PRODUCT_ID, enforced through the constraint OZF_OFFER_ADJUSTMENT_PROD_PK. Foreign keys anchor the row to its parent adjustment, to the discount line, and to specific discount products, so the business-key candidates are effectively the combination of OFFER_ADJUSTMENT_ID, OFFER_DISCOUNT_LINE_ID, and OFF_DISCOUNT_PRODUCT_ID rather than a single natural key column.

• OFFER_ADJUSTMENT_ID – references the parent offer adjustment to which the product row belongs.
• OFFER_DISCOUNT_LINE_ID – foreign key to OZF_OFFER_DISCOUNT_LINES, linking the product to a specific discount line on the adjustment.
• OFF_DISCOUNT_PRODUCT_ID – foreign key to OZF_OFFER_DISCOUNT_PRODUCTS, identifying the product/discount-product definition being applied.
• PRODUCT_CONTEXT, PRODUCT_ATTRIBUTE, PRODUCT_ATTR_VALUE – the flexfield-style qualifier triplet that defines how products are matched (context, attribute name, and value), enabling flexible product qualification rules.
• EXCLUDER_FLAG – indicates whether the row is an exclusion (product is excluded from the adjustment) rather than an inclusion.
• APPLY_DISCOUNT_FLAG – indicates whether the discount should be applied for this product.
• INCLUDE_VOLUME_FLAG – indicates whether this product's volume is included in the adjustment calculation.
• OBJECT_VERSION_NUMBER – optimistic-locking column used by the Trade Management APIs and OAF pages.
• SECURITY_GROUP_ID – foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group data isolation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – standard EBS WHO columns supporting audit and concurrency.

Common Use Cases and Queries

Typical use cases include auditing which items are covered by a promotion, troubleshooting why a discount did or did not fire at order entry, and reporting on product coverage for a given adjustment. A representative query retrieves all products on an adjustment:

• SELECT oap.offer_adjustment_product_id, oap.off_discount_product_id, oap.product_context, oap.product_attribute, oap.product_attr_value, oap.excluder_flag, oap.apply_discount_flag FROM ozf_offer_adjustment_products oap WHERE oap.offer_adjustment_id = :p_adjustment_id;
• Joining to OZF_OFFER_DISCOUNT_LINES on OFFER_DISCOUNT_LINE_ID isolates products belonging to a specific discount line.
• Filtering EXCLUDER_FLAG = 'Y' lists exclusions; EXCLUDER_FLAG = 'N' lists included products.

Reporting often aggregates by OFFER_ADJUSTMENT_ID to count qualifying versus excluded products, or joins to OZF_OFFER_DISCOUNT_PRODUCTS to resolve human-readable product identifiers.

Related Objects

• OZF_OFFER_DISCOUNT_LINES – joined via OFFER_DISCOUNT_LINE_ID; defines the discount line each product belongs to.
• OZF_OFFER_DISCOUNT_PRODUCTS – joined via OFF_DISCOUNT_PRODUCT_ID; provides the product/discount-product definition.
• OZF_OFFER_ADJUSTMENTS – parent entity referenced by OFFER_ADJUSTMENT_ID, holding adjustment-level rules.
• FND_SECURITY_GROUPS – referenced via SECURITY_GROUP_ID for security-group partitioning.
• MTL_SYSTEM_ITEMS_VL / MTL_SYSTEM_ITEMS_B – indirectly resolved through product attributes or discount products to obtain item descriptions.
• OZF_OFFER_ADJUSTMENT_PRODUCTS APIs – the Trade Management OAF pages and PL/SQL APIs that maintain these rows, using OBJECT_VERSION_NUMBER for concurrency control.