Results for “ozf_offer_adjustment_lines”

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

Overview

OZF_OFFER_ADJUSTMENT_LINES is a Trade Management (OZF) transaction table within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It stores the discount information associated with an offer adjustment, functioning as the line-level detail that qualifies and quantifies the monetary or accrual effect of an adjustment header. Offer adjustments represent negotiated changes to pricing, rebates, or promotional accruals, and this table captures the individual discount definitions, arithmetic behavior, and effective dating that govern how each adjustment is applied.

From a Data Vault modeling perspective, the mined foreign key structure suggests a satellite-leaning classification. The table carries a surrogate primary key and a foreign key to a parent header, together with descriptive and numeric attributes (discounts, operators, dates) that are typical of satellite content attached to a hub or link. This classification is a heuristic suggestion only; the table is a standard relational EBS object rather than a physical Data Vault construct.

Key Information Stored

The table contains 21 documented columns. The most operationally significant include:

• OFFER_ADJUSTMENT_LINE_ID — The surrogate primary key, enforced by OZF_OFFER_ADJUSTMENT_LINES_PK and reinforced by the unique index OZF_OFFER_ADJUSTMENT_LINES_U1. This is the business-key candidate for unique identification of a line.
• OFFER_ADJUSTMENT_ID — Foreign key to OZF_OFFER_ADJUSTMENTS_B, tying each line to its parent adjustment header.
• LIST_LINE_ID and LIST_LINE_ID_TD — References to the QP_LIST_LINES pricing list line and its translated/denormalized counterpart.
• LIST_HEADER_ID — Identifies the pricing list header context for the discount.
• ARITHMETIC_OPERATOR — Defines how the discount is calculated or combined.
• ORIGINAL_DISCOUNT, MODIFIED_DISCOUNT, and their _TD counterparts — Capture the baseline and revised discount values, supporting audit and change tracking.
• QUANTITY — The quantity basis for the discount line.
• ACCRUAL_FLAG — Indicates whether the line participates in accrual processing.
• DISCOUNT_END_DATE — Effective end date for the discount.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-org and data security filtering.

Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and OBJECT_VERSION_NUMBER support concurrency control and auditing.

Common Use Cases and Queries

Typical scenarios include reconciling offer adjustments to pricing list lines, reporting discount accruals, and auditing changes between original and modified discount values. A common join pattern retrieves line detail against the parent header:

• SELECT l.offer_adjustment_line_id, l.original_discount, l.modified_discount, l.arithmetic_operator FROM ozf.ozf_offer_adjustment_lines l WHERE l.offer_adjustment_id = :adjustment_id;
• Join to QP_LIST_LINES via LIST_LINE_ID to resolve the underlying price list line definition.
• Filter by SECURITY_GROUP_ID to respect operating unit or responsibility data security.
• Compare ORIGINAL_DISCOUNT against MODIFIED_DISCOUNT and the _TD columns for change-analysis reporting.
• Use ACCRUAL_FLAG and DISCOUNT_END_DATE to drive accrual cut-off and period-end reporting.

Related Objects

• OZF_OFFER_ADJUSTMENTS_B — Parent header; joined on OFFER_ADJUSTMENT_ID.
• QP_LIST_LINES — Pricing list line definition; joined on LIST_LINE_ID.
• FND_SECURITY_GROUPS — Data security grouping; joined on SECURITY_GROUP_ID.
• OZF_OFFER_ADJUSTMENTS_TL — Translated header attributes for the parent adjustment.
• QP_LIST_HEADERS_B / QP_LIST_HEADERS_TL — Pricing list header context referenced by LIST_HEADER_ID.
• OZF_OFFER_ADJUSTMENTS_V — Common reporting view layered over the adjustment header and lines.