Search Results ozf_resale_lines_int_all




Overview
Explore in AI Chat

Overview

OZF_RESALE_LINES_INT_ALL is the Resale Lines Interface Table within the Oracle Trade Management (OZF) application, a component of the Oracle E-Business Suite supply chain and channel revenue management stack. The table functions as the staging and interface repository through which external sources or upstream EBS processes load resale and product transfer line data before validation, adjudication, and eventual transfer into the permanent Trade Management resale transaction tables. It is a transactional interface table, not a setup table, and holds both inbound data loaded by concurrent programs and outbound data written during resale processing cycles.

In Oracle EBS 12.1.1 and 12.2.2, this object resides in the OZF schema (product code OZF, status VALID). Its documented physical schema comprises 232 columns, reflecting the very wide denormalized shape typical of interface tables, which carry address, contact, pricing, agreement, and item segment attributes in a single flat structure. Based on the foreign key structure mined from the metadata, a heuristic Data Vault classification of link is reasonable: the table predominantly associates existing hubs such as customer accounts, customer sites, order types, and resale batches, rather than serving as an independent business hub or a single-source descriptive satellite.

Key Information Stored

The primary key is the surrogate identifier RESALE_LINE_INT_ID, backed by the unique index OZF_RESALE_LINES_INT_ALL_U1 (RESALE_LINE_INT_ID) and the constraint OZF_RESALE_LINES_INT_ALL_PK. This column is the only documented business-key candidate; the remaining uniqueness in the table is inherited through foreign key relationships rather than native unique indexes.

The most operationally significant columns include:

The table also carries numerous denormalized name, address, and contact columns for the ship-from, sold-from, bill-to, ship-to, and end-customer parties, plus generic HEADER_ATTRIBUTE and LINE_ATTRIBUTE descriptive flexfield columns.

Common Use Cases and Queries

Typical scenarios include monitoring inbound interface loads, detecting validation failures, and reconciling external claims or transfer data against EBS customers and orders.

Batch status monitoring groups lines by their parent resale batch:

  • SELECT RESALE_BATCH_ID, STATUS_CODE, COUNT(*)
  • FROM OZF_RESALE_LINES_INT_ALL
  • GROUP BY RESALE_BATCH_ID, STATUS_CODE;

Failed-line investigation filters on response and reject diagnostics, joining currency and item context:

  • SELECT RESALE_LINE_INT_ID, ITEM_NUMBER, QUANTITY, RESPONSE_CODE, REJECT_REASON_CODE
  • FROM OZF_RESALE_LINES_INT_ALL
  • WHERE STATUS_CODE = 'ERROR';

Customer reconciliation joins billing context to the trading partner:

  • SELECT l.RESALE_LINE_INT_ID, c.account_number
  • FROM OZF_RESALE_LINES_INT_ALL l, HZ_CUST_ACCOUNTS c
  • WHERE l.BILL_TO_CUST_ACCOUNT_ID = c.cust_account_id;

Reporting commonly aggregates claimed, allowed, and accepted amounts by order type or agreement to support channel revenue analysis.

Related Objects

The following objects are referenced by, or logically bound to, this table through the documented relationships:

  • OZF_RESALE_BATCHES_ALL — parent batch table; join on RESALE_BATCH_ID.
  • HZ_CUST_ACCOUNTS — trading partner account; join on BILL_TO_CUST_ACCOUNT_ID and SHIP_TO_CUST_ACCOUNT_ID.
  • HZ_CUST_SITE_USES_ALL — customer site usage; join on BILL_TO_SITE_USE_ID and SHIP_TO_SITE_USE_ID.
  • SO_ORDER_TYPES_115_ALL — order type definitions; join on ORDER_TYPE_ID.
  • FND_SECURITY_GROUPS — security group reference; join on SECURITY_GROUP_ID.
  • MTL_SYSTEM_ITEMS_B — item master reference via INVENTORY_ITEM_ID, used to resolve item descriptions and segments.
  • OZF_RESALE_LINES_ALL — the permanent resale line table into which validated interface records are ultimately transferred.