Results for “ozf_offer_adjustments_b”

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

Overview

OZF_OFFER_ADJUSTMENTS_B is the base table in the Oracle Trade Management (OZF) module that stores all adjustments applied to an offer. In Oracle EBS 12.1.1 and 12.2.2, offers represent promotional or trade programs created by channel, sales, or marketing organizations, and adjustments define the specific incentive mechanics — such as discounts, rebates, accruals, or lump-sum settlements — attached to those offers. Each row in this table represents a single offer adjustment header, identified by the surrogate primary key OFFER_ADJUSTMENT_ID.

The table resides in the OZF schema with 32 documented columns. From a Data Vault modeling perspective, the FK structure suggests classifying this entity as hub-leaning: OFFER_ADJUSTMENT_ID functions as a durable business key, with descriptive attributes such as EFFECTIVE_DATE, STATUS_CODE, and SETTLEMENT_CODE attached. This structure supports the interpretation that OZF_OFFER_ADJUSTMENTS_B behaves as a central hub for adjustment identities, with child tables (translations, lines, and tiers) acting as satellites or dependent details.

Key Information Stored

The most significant columns in OZF_OFFER_ADJUSTMENTS_B are:

• OFFER_ADJUSTMENT_ID — Surrogate primary key (OZF_OFFER_ADJUSTMENTS_B_PK / OZF_OFFER_ADJUSTMENTS_B_U1). Unique identifier for the adjustment.
• LIST_HEADER_ID — Foreign key to OZF_OFFERS, linking the adjustment to its parent offer.
• EFFECTIVE_DATE — Date the adjustment becomes active.
• APPROVED_DATE — Date the adjustment was approved through workflow.
• SETTLEMENT_CODE — Determines how the adjustment is settled (e.g., accrual, off-invoice, lump sum).
• STATUS_CODE — Workflow-driven lifecycle status of the adjustment.
• VERSION — Tracks revision numbering for the adjustment record.
• BUDGET_ADJUSTED_FLAG — Indicates whether a budget adjustment is associated.
• COMMENTS — Free-text descriptive notes.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS for row-level security.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/BC4J framework.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — DFF (Descriptive Flexfield) columns for customer-defined extensibility.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Typical implementations query this table to report adjustment headers by offer, filter by status or effective date, or join to child tables to reconstruct the full adjustment definition. A common query retrieves all active adjustments for a specific offer:

• SELECT oa.OFFER_ADJUSTMENT_ID, oa.STATUS_CODE, oa.SETTLEMENT_CODE, oa.EFFECTIVE_DATE FROM OZF.OZF_OFFER_ADJUSTMENTS_B oa WHERE oa.LIST_HEADER_ID = :offer_id AND oa.STATUS_CODE = 'APPROVED';
• Reporting on approved adjustments over a date range: filter on APPROVED_DATE between period start and end.
• Extracting settlement breakdowns by SETTLEMENT_CODE for accrual versus off-invoice reconciliation.
• Retrieving descriptive text via the translation table OZF_OFFER_ADJUSTMENTS_TL, joined on OFFER_ADJUSTMENT_ID with the appropriate LANGUAGE column.
• Data migration or integration extracts using CREATION_DATE and LAST_UPDATE_DATE as incremental watermarks.
• Security-aware queries that constrain SECURITY_GROUP_ID against FND_SECURITY_GROUPS.

Related Objects

• OZF_OFFERS — Parent table; joined via OZF_OFFER_ADJUSTMENTS_B.LIST_HEADER_ID = OZF_OFFERS.LIST_HEADER_ID.
• OZF_OFFER_ADJUSTMENTS_TL — Translation table holding language-specific names and descriptions; joins on OFFER_ADJUSTMENT_ID.
• OZF_OFFER_ADJUSTMENT_LINES — Child table defining adjustment lines; joins on OFFER_ADJUSTMENT_ID.
• OZF_OFFER_ADJUSTMENT_TIERS — Child table defining tiered thresholds and rates; joins on OFFER_ADJUSTMENT_ID.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for row-level access control.

The TL, LINES, and TIERS tables form the dependent hierarchy of an adjustment and must be queried together to fully resolve the business definition of an offer adjustment.