Search Results ozf_claims_all

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:

• OZF_BATCHES_ALL via BATCH_ID
• HZ_CUST_ACCOUNTS via CUST_ACCOUNT_ID and RELATED_CUST_ACCOUNT_ID
• OZF_CLAIM_TYPES_ALL_B via CLAIM_TYPE_ID
• OZF_REQUEST_HEADERS_ALL_B via SOURCE_OBJECT_ID
• OE_ORDER_HEADERS_ALL via PAYMENT_REFERENCE_ID
• PO_VENDORS via VENDOR_ID

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

• OZF_CLAIM_LINES_ALL via CLAIM_ID
• OZF_CLAIM_ADJUSTMENTS_ALL via CLAIM_ID
• OZF_FUNDS_PAID_ALL via CLAIM_ID
• OZF_CLAIMS_HISTORY_ALL via CLAIM_ID
• OZF_CLAIM_OFFER_PERF_ALL via CLAIM_ID
• OZF_ACCTNG_EVENTS_ALL via SOURCE_ID (where the source is the claim)