Search Results ozf_resale_headers_all_pk

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:

• RESALE_HEADER_ID — surrogate primary key and foreign key to OZF_RESALE_LINES_ALL.
• ORDER_NUMBER, ORDER_TYPE, ORDER_TYPE_ID, ORDER_CATEGORY — order context, with ORDER_TYPE_ID referencing SO_ORDER_TYPES_115_ALL.
• STATUS_CODE — workflow or processing status of the resale header.
• DATE_ORDERED, DATE_SHIPPED — key transactional dates for reporting.
• BILL_TO_CUST_ACCOUNT_ID, BILL_TO_SITE_USE_ID — billing party and site references to HZ_CUST_ACCOUNTS and HZ_CUST_SITE_USES_ALL.
• SHIP_TO_CUST_ACCOUNT_ID, SHIP_TO_SITE_USE_ID — shipping party and site references to the same HZ tables.
• SHIP_TO_PARTY_NAME, SHIP_TO_ADDRESS, SHIP_TO_CITY, SHIP_TO_STATE, SHIP_TO_POSTAL_CODE, SHIP_TO_COUNTRY — denormalized shipping address snapshot.
• HEADER_ATTRIBUTE1 through HEADER_ATTRIBUTE15 and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield segments.
• ORG_ID, SECURITY_GROUP_ID — multi-org and security group context, the latter referencing FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit and concurrency columns.

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.