Search Results ozf_sd_batch_line_disputes




Overview
Explore in AI Chat

Overview

The OZF.OZF_SD_BATCH_LINE_DISPUTES table is a Trade Management (OZF) module object within Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores line-level dispute information for Supplier Ship and Debit (SD) batches processed in Oracle Trade Management. Supplier Ship and Debit is the mechanism by which a supplier reimburses a distributor or reseller for promotional allowances, rebates, or price protections tied to specific shipment and debit transactions. When a discrepancy arises between what a supplier acknowledges and what the distributor claims — for example, an insufficient credit, a rejected line, or a disputed rebate amount — the dispute is captured at the batch line level in this table.

The object is documented in ETRM as a standalone table with 17 columns, primary key OZF_SD_BATCH_LINE_DISPUTES_PK on BATCH_LINE_DISPUTE_ID, and a unique index OZF_SD_BATCH_LINE_DISPUTES_U1 on the same column. Under a heuristic Data Vault classification mined from the foreign key structure, this table is modeled as standalone — it does not function as a classic hub, link, or satellite, since its only documented foreign key points to a security construct rather than a business entity. In practice it behaves as a line-level satellite or detail table attached to a ship-and-debit batch hierarchy, carrying descriptive dispute attributes plus standard WHO/audit columns.

Key Information Stored

The most significant columns in this table are:

The surrogate key is BATCH_LINE_DISPUTE_ID; the unique index U1 is documented as the business-key candidate. The composite of BATCH_ID and BATCH_LINE_ID functions as a logical parent reference even though no FK constraint to the batch tables is documented in the metadata.

Common Use Cases and Queries

Typical reporting scenarios include identifying disputed lines within a batch, measuring dispute rates by reason code, and reviewing flagged disputes pending resolution.

SELECT d.BATCH_LINE_DISPUTE_ID, d.BATCH_ID, d.BATCH_LINE_ID,
       d.DISPUTE_CODE, d.REVIEW_FLAG, d.CREATION_DATE
FROM   OZF.OZF_SD_BATCH_LINE_DISPUTES d
WHERE  d.BATCH_ID = :p_batch_id;

A dispute-reason analysis query groups by DISPUTE_CODE:

SELECT DISPUTE_CODE, COUNT(*) dispute_count
FROM   OZF.OZF_SD_BATCH_LINE_DISPUTES
WHERE  SECURITY_GROUP_ID = :p_security_group
GROUP  BY DISPUTE_CODE
ORDER  BY dispute_count DESC;

Users may also filter on REVIEW_FLAG to surface disputes requiring manual attention, and join to the concurrent request columns to trace which batch program created the dispute.

Related Objects

  • FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID; the only documented foreign key relationship.
  • Supplier Ship and Debit batch header table (OZF SD batch) — referenced via BATCH_ID.
  • Supplier Ship and Debit batch line table — referenced via BATCH_LINE_ID.
  • FND_CONCURRENT_REQUESTS — associated through REQUEST_ID for audit tracing.
  • Trade Management SD batch concurrent programs — populate the dispute rows during batch validation and reconciliation.
  • OZF Trade Management reporting views and OBIEE/Discoverer extracts that consolidate dispute metrics.

The object is Oracle proprietary and confidential, distributed under legal notices as part of the ETRM documentation set.