Search Results ozf_resale_headers_all




Overview
Explore in AI Chat

Overview

OZF_RESALE_HEADERS_ALL is the transactional header table for resale information within the Oracle Trade Management (OZF) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the top-level attributes of a resale transaction, capturing the parties, addresses, shipment and billing details, and order context associated with a resale event. The table is owned by the OZF schema and is documented in the ETRM reference with 92 columns.

Within the Trade Management data model, this table functions as the parent of OZF_RESALE_LINES_ALL, which references it through RESALE_HEADER_ID. The header therefore anchors the line-level detail of each resale document. Its foreign keys reach outward into the Trading Community Architecture (HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES_ALL), Order Management order types (SO_ORDER_TYPES_115_ALL), and FND_SECURITY_GROUPS, positioning the table as a transaction-level record that consolidates party, address, and order context. Based on its foreign key structure, the heuristic Data Vault classification for this object is satellite-leaning; that is, it is best modeled as a satellite attached to the customer and party hubs it references, rather than as an independent hub.

Key Information Stored

The surrogate primary key is RESALE_HEADER_ID, enforced by OZF_RESALE_HEADERS_ALL_PK and also reinforced by the unique index OZF_RESALE_HEADERS_ALL_U1, which represents the business-key candidate on the same column. Notable attributes include:

Common Use Cases and Queries

Typical reporting scenarios include resale volume by customer, shipment-to-bill reconciliation, and order-type analysis. A common join retrieves header with its lines:

  • SELECT h.resale_header_id, h.order_number, h.status_code, l.resale_line_id FROM ozf_resale_headers_all h, ozf_resale_lines_all l WHERE h.resale_header_id = l.resale_header_id;
  • Resolving bill-to parties: SELECT h.resale_header_id, c.account_name FROM ozf_resale_headers_all h, hz_cust_accounts c WHERE h.bill_to_cust_account_id = c.cust_account_id;
  • Filtering by status: SELECT * FROM ozf_resale_headers_all WHERE status_code = :status AND org_id = :org_id.

Related Objects

  • OZF_RESALE_LINES_ALL — child table joined on RESALE_HEADER_ID.
  • HZ_CUST_ACCOUNTS — referenced through BILL_TO_CUST_ACCOUNT_ID and SHIP_TO_CUST_ACCOUNT_ID.
  • HZ_CUST_SITE_USES_ALL — referenced through BILL_TO_SITE_USE_ID and SHIP_TO_SITE_USE_ID.
  • SO_ORDER_TYPES_115_ALL — referenced through ORDER_TYPE_ID.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID.