Search Results ozf_resale_lines_all




Overview
Explore in AI Chat

Overview

OZF_RESALE_LINES_ALL is the transactional detail table within Oracle Trade Management (OZF) that stores chargeback line information. In Oracle EBS 12.1.1 and 12.2.2, it functions as the line-level counterpart to OZF_RESALE_HEADERS_ALL, capturing the individual resale/chargeback transactions processed against trade promotion and channel rebate agreements. Each row represents a single resale line documenting a product transfer between trading partners, enriched with party, pricing, item, and sourcing details used to calculate and validate chargeback claims.

From a Data Vault modeling perspective, the heuristic classification for this table is satellite-leaning. The presence of a single-column surrogate primary key (RESALE_LINE_ID) alongside multiple foreign keys — RESALE_HEADER_ID, BILL_TO_CUST_ACCOUNT_ID, SHIP_TO_CUST_ACCOUNT_ID, and others — suggests the table acts as an aggregated descriptive satellite attached to parent hubs such as customers, inventory items, and resale headers, rather than as a pure hub or link. This classification is offered as a modeling suggestion, and the table's 194 columns reinforce its role as a wide descriptive structure.

Key Information Stored

The documented schema contains 194 columns. The most operationally significant among them include:

Common Use Cases and Queries

Typical uses include chargeback validation, resale reporting by customer or item, and reconciliation of incoming resale feeds against open claims. A common query joins lines to headers and customer accounts:

SELECT l.resale_line_id, l.resale_header_id, h.resale_number,
       l.bill_to_cust_account_id, l.quantity, l.selling_price
FROM   ozf_resale_lines_all l,
       ozf_resale_headers_all h
WHERE  l.resale_header_id = h.resale_header_id
AND    l.org_id = :p_org_id;

Reporting often aggregates resale quantities by INVENTORY_ITEM_ID or END_CUST_PARTY_ID to measure indirect sales, or joins to OZF_RESALE_ADJUSTMENTS_ALL to net adjustments against a given line.

Related Objects

  • OZF_RESALE_HEADERS_ALL — parent table; joined on RESALE_HEADER_ID.
  • OZF_RESALE_ADJUSTMENTS_ALL — child table referencing RESALE_LINE_ID, storing line-level adjustments.
  • OZF_RESALE_BATCH_LINE_MAPS_ALL — maps batch transactions to resale lines via RESALE_LINE_ID.
  • HZ_CUST_ACCOUNTS — source of bill-to and ship-to customer references.
  • HZ_CUST_SITE_USES_ALL — source of bill-to and ship-to site use references.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for data security partitioning.