Search Results ozf_claims_all




Overview
Explore in AI Chat

Overview

The OZF_CLAIMS_ALL table is a core transactional entity within Oracle E-Business Suite Release 12.1.1 and 12.2.2, specifically for the Trade Management (OZF) module. It serves as the primary repository for claim header information. A claim represents a formal request, typically from a channel partner or customer, for funds or deductions related to trade promotions, discounts, or other incentive programs. This table stores the master definition of each claim, including its status, financial context, involved parties, and type. As a multi-organization table (indicated by the '_ALL' suffix), it segregates data by operating unit, enabling shared service deployments. Its central role is to act as the parent record for all detailed claim lines, adjustments, payments, and audit history.

Key Information Stored

The table's primary key is CLAIM_ID, which uniquely identifies each claim header. Based on the documented foreign key relationships, other critical columns include organizational and financial identifiers like SET_OF_BOOKS_ID and BATCH_ID. It stores key business relationships through columns such as CUST_ACCOUNT_ID (the claimant), VENDOR_ID, CLAIM_TYPE_ID, and REASON_CODE_ID. The table also manages claim lifecycle and processing data, including references to a source object (SOURCE_OBJECT_ID), payment references (PAYMENT_REFERENCE_ID), and workflow task templates (TASK_TEMPLATE_GROUP_ID). The SPLIT_FROM_CLAIM_ID column supports the business process of dividing a larger claim into smaller ones. Standard Oracle EBS audit columns like CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, and LAST_UPDATED_BY are also present.

Common Use Cases and Queries

This table is fundamental for claim lifecycle reporting, audit inquiries, and financial reconciliation. Common operational reports include listing all claims for a specific customer, summarizing claims by status within a date range, or tracing claims back to their originating trade deal or request. A typical query might join to customer (HZ_CUST_ACCOUNTS) and claim type (OZF_CLAIM_TYPES_ALL_B) tables for a detailed status report. For financial auditing, queries often join to child tables like OZF_CLAIM_LINES_ALL and OZF_FUNDS_PAID_ALL to reconcile claimed amounts against paid amounts. Technical integrations and data migrations frequently utilize this table as the starting point for extracting or loading claim data, leveraging the CLAIM_ID as the key reference.

Sample SQL Pattern:

  • SELECT cl.claim_number, cl.claim_status, cl.total_claimed_amount, hca.account_number, ctl.name claim_type FROM ozf_claims_all cl, hz_cust_accounts hca, ozf_claim_types_all_b ctl WHERE cl.cust_account_id = hca.cust_account_id AND cl.claim_type_id = ctl.claim_type_id AND cl.org_id = :p_org_id;

Related Objects

The OZF_CLAIMS_ALL table has extensive relationships, acting as a central hub in the Trade Management schema. Key parent (referenced) tables include:

It is the parent to numerous critical child tables, which store detail records for each claim: