Search Results ozf_funds_paid_all




Overview
Explore in AI Chat

Overview

The OZF_FUNDS_PAID_ALL table is a core transactional entity within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the definitive repository for detailed records of funds that have been disbursed or paid out. This table is critical for tracking the financial execution of trade promotions, claims, and other incentive programs managed within the system. As a multi-organization table (indicated by the "_ALL" suffix), it stores data across all operating units, enabling centralized financial reporting and compliance. Its primary role is to provide a granular audit trail of payments made against utilized funds, linking the financial outflow back to specific claims and fund utilization records.

Key Information Stored

While the provided metadata does not list specific columns, the documented primary and foreign keys reveal the core data structure. The table's primary key is the PAID_ID column, uniquely identifying each payment record. The table's relationships indicate it stores at least two critical foreign key references: the UTILIZATION_ID, which links the payment to a specific record of fund utilization in the OZF_FUNDS_UTILIZED_ALL_B table, and the CLAIM_ID, which links the payment to its originating claim in the OZF_CLAIMS_ALL table. This structure implies the table also holds payment-specific attributes such as payment amount, date, status, currency, and potentially payment method identifiers, forming a complete record of the disbursement transaction.

Common Use Cases and Queries

This table is central to financial reconciliation and payment auditing processes. Common use cases include generating payment registers for accounting, verifying paid amounts against claimed amounts for specific promotions, and analyzing payment cycles. A typical reporting query would join this table to related claim and utilization data to provide a comprehensive view of fund disbursements. For example, to list all payments for a specific claim, one might use a SQL pattern such as: SELECT * FROM ozf_funds_paid_all WHERE claim_id = <claim_id>;. For payment analysis, a join to OZF_FUNDS_UTILIZED_ALL_B would trace the payment back to the original budget or fund source, supporting spend versus budget reporting.

Related Objects

The OZF_FUNDS_PAID_ALL table is integral to the Trade Management data model, with documented foreign key relationships to two primary tables:

  • OZF_FUNDS_UTILIZED_ALL_B: Linked via the UTILIZATION_ID column. This relationship ties each payment to a specific instance of fund commitment or reservation, ensuring payments are made against authorized utilizations.
  • OZF_CLAIMS_ALL: Linked via the CLAIM_ID column. This is the foundational relationship, connecting the disbursement of funds to the submitted claim that requested the payment, enabling end-to-end tracking from claim submission to settlement.
These relationships are enforced through the table's primary key (FUNDPD_PK on PAID_ID) and the corresponding foreign keys in the related tables, maintaining referential integrity for all payment transactions.