Search Results ozf_settlement_docs_all




Overview
Explore in AI Chat

Overview

OZF_SETTLEMENT_DOCS_ALL is a transactional table in the Oracle Trade Management (OZF) module of Oracle E-Business Suite, validated in releases 12.1.1 and 12.2.2. It stores settlement document details generated when trade management claims, deductions, and promotional accruals are resolved and paid. In the trade management lifecycle, a claim is raised against a promotion or customer program, and once approved, the settlement process either offsets the claim against an open receivable or issues a payment. OZF_SETTLEMENT_DOCS_ALL captures the resulting settlement document, its payment instrument, its monetary amount, and its accounting disposition, thereby acting as the record of financial closure for trade promotion activity.

The ETRM metadata classifies this table heuristically as a standalone Data Vault structure. In modeling terms, this is best treated as a satellite or transaction-level fact table anchored on its own business key rather than as a pure hub or link; the foreign keys to claims, claim lines, invoice payments, and security groups give it the appearance of a link, but the table also carries extensive descriptive and measure columns. The physical table resides in the OZF schema and contains 53 documented columns.

Key Information Stored

The surrogate primary key is SETTLEMENT_DOC_ID, enforced by constraint OZF_SETTLEMENT_DOCS_PK. A unique index, OZF_SETTLEMENT_DOCS_U1, also exists on SETTLEMENT_DOC_ID, confirming it as the primary business-key candidate. The most significant columns include:

Common Use Cases and Queries

Typical reporting scenarios include reconciling trade settlements to AP payments, analyzing outstanding versus paid claims, and auditing settlement amounts by organization or period. A common query joins settlement documents to their claims to report settlement status:

SELECT s.settlement_number, s.settlement_date, s.settlement_amount,
       s.payment_status, c.claim_number
FROM   ozf_settlement_docs_all s,
       ozf_claims_all c
WHERE  s.claim_id = c.claim_id
AND    s.org_id = :p_org_id;

Reconciliation reporting joins to AP_INVOICE_PAYMENTS_ALL on INVOICE_PAYMENT_ID to confirm that settlements are matched to disbursements. Period-close analysis aggregates SETTLEMENT_ACCTD_AMOUNT by GL_DATE. Exception reporting selects rows where STATUS_CODE remains open past a threshold.

Related Objects

  • OZF_CLAIMS_ALL — referenced via CLAIM_ID; the claim header settled by this document.
  • OZF_CLAIM_LINES_ALL — referenced via CLAIM_LINE_ID; the specific claim line settled.
  • AP_INVOICE_PAYMENTS_ALL — referenced via INVOICE_PAYMENT_ID; the AP payment that funded the settlement.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; enforces data security.
  • OZF_FUNDS_PAID_ALL — references this table via SETTLEMENT_DOC_ID; records funds actually paid.