Results for “ozf_offer_discount_lines”

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

Overview

OZF_OFFER_DISCOUNT_LINES is a Trade Management (OZF) transactional table that stores the individual discount lines belonging to a Net Accrual Offer. Within the Oracle EBS 12.1.1 and 12.2.2 data model, it functions as the central detail entity for offer-based accruals: a single offer may carry many discount lines, and each line defines the volume thresholds, tiering logic, discount value, and pricing phase that govern how accrual or discount amounts are calculated against sales volume. The table is owned by the OZF schema and is reported as VALID in the ETRM repository, with 48 documented columns.

From a Data Vault modeling perspective, the metadata suggests a hub-leaning classification. The table is anchored by a single-column surrogate primary key, OFFER_DISCOUNT_LINE_ID, with relatively stable identity semantics and numerous downstream references. In a Data Vault design this would typically be modeled as a hub for the discount line business entity, with descriptive and tiering attributes split into one or more satellites, and links to offers, pricing phases, and product relationships. This is a heuristic suggestion only; the physical implementation remains a conventional normalized relational table within the EBS schema.

Key Information Stored

The table's identity is defined by the surrogate primary key OFFER_DISCOUNT_LINE_ID, which is also enforced by the unique index OZF_OFFER_DISCOUNT_LINES_U1 and serves as the principal business-key candidate. The most significant columns include:

• OFFER_ID — foreign key to OZF_OFFERS; ties the discount line to its parent Net Accrual Offer.
• PARENT_DISCOUNT_LINE_ID — self-referencing hierarchy column supporting parent/child discount line structures.
• VOLUME_FROM, VOLUME_TO, VOLUME_OPERATOR, VOLUME_TYPE, VOLUME_BREAK_TYPE — define the volume band and comparison logic that qualify a line.
• DISCOUNT and DISCOUNT_TYPE — the discount or accrual value and its interpretation (for example, percentage versus amount).
• TIER_TYPE and TIER_LEVEL — configure tiered accrual structures.
• PRICING_PHASE_ID — foreign key to QP_PRICING_PHASES, linking the line into the pricing engine phase sequencing.
• FORMULA_ID — associates a calculation formula with the line.
• START_DATE_ACTIVE and END_DATE_ACTIVE — effective dating for the discount line.
• CHANNEL_ID, ADJUSTMENT_FLAG, PRECEDENCE, INCOMPATIBILITY_GROUP — control channel applicability, adjustment treatment, and conflict resolution.
• SCAN_VALUE, SCAN_DATA_QUANTITY, SCAN_UNIT_FORECAST, BUCKET — support accrual scanning and bucket logic.
• OBJECT_VERSION_NUMBER and the standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — concurrency control and auditability.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard descriptive flexfield extension columns.

Common Use Cases and Queries

Typical reporting retrieves all discount lines for a given offer, often joining to OZF_OFFERS to obtain the offer name and status:

SELECT odl.offer_discount_line_id, odl.offer_id, odl.volume_from,
       odl.volume_to, odl.discount, odl.discount_type, odl.tier_level
FROM   ozf.ozf_offer_discount_lines odl
WHERE  odl.offer_id = :offer_id
ORDER  BY odl.precedence, odl.tier_level;

Effective-dated analysis uses START_DATE_ACTIVE and END_DATE_ACTIVE to identify currently valid lines, while accrual reconciliation joins the line to OZF_OFFER_DISCOUNT_PRODUCTS and OZF_QP_DISCOUNTS to trace product applicability and generated pricing discounts. Because PRICING_PHASE_ID references QP_PRICING_PHASES, integration queries commonly join to the pricing phase table to understand phase ordering. The self-referencing PARENT_DISCOUNT_LINE_ID supports hierarchical reporting, for example to expand parent/child line structures, and INCOMPATIBILITY_GROUP with PRECEDENCE is used to detect conflicting discount configurations.

Related Objects

• OZF_OFFERS — joined on OFFER_ID; the header record of the Net Accrual Offer.
• QP_PRICING_PHASES — joined on PRICING_PHASE_ID; defines pricing engine phase sequencing.
• OZF_OFFER_DISCOUNT_PRODUCTS — references OFFER_DISCOUNT_LINE_ID; holds products eligible for each line.
• OZF_DISCOUNT_PRODUCT_RELN — references OFFER_DISCOUNT_LINE_ID; product relationship detail.
• OZF_OFFER_ADJUSTMENT_TIERS — references OFFER_DISCOUNT_LINE_ID; tier definitions for adjustments.
• OZF_OFFER_ADJUSTMENT_PRODUCTS — references OFFER_DISCOUNT_LINE_ID; adjustment product detail.
• OZF_OFFER_QUALIFIERS — references OFFER_DISCOUNT_LINE_ID; qualifier conditions for the line.
• OZF_QP_DISCOUNTS — references OFFER_DISCOUNT_LINE_ID; pricing discount records generated from the line.
• OZF_OFFR_DISC_STRUCT_NAME_B — references OFFER_DISCOUNT_LINE_ID; discount structure naming.