Search Results ozf_claim_lines_all




Overview
Explore in AI Chat

Overview

The OZF_CLAIM_LINES_ALL table is a core transactional data object within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the primary repository for storing individual line-level details of claims processed through the system. Claims in Trade Management typically represent requests for funds, such as rebates, discounts, or promotional payments, made by trading partners like distributors or retailers. This table is integral to the claim lifecycle, capturing the granular financial and product details that aggregate to form a complete claim header. As an "ALL" table, it is designed to support multi-organization access (MOAC) by storing data across all operating units, with security typically enforced by a VPD (Virtual Private Database) policy.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as CLAIM_LINE_ID, a unique system-generated identifier for each claim line. Based on the table's purpose and common Trade Management data models, it typically stores critical information such as the product or service being claimed, the quantity, unit price, extended amount, claim reason code, and accrual status. Each record is logically tied to a parent claim header via the foreign key column CLAIM_ID, which references the OZF_CLAIMS_ALL table. The table likely includes standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and an operating unit identifier (ORG_ID).

Common Use Cases and Queries

This table is central to operational reporting and reconciliation for trade promotions. Common use cases include analyzing claim line details for a specific promotion, auditing claim amounts by product, and calculating total liabilities. A fundamental query retrieves all lines for a given claim header, often joining to product and claim header tables for a complete view:

  • SELECT cl.* FROM ozf_claim_lines_all cl WHERE cl.claim_id = :p_claim_id;

Analytical reporting frequently aggregates data from this table to summarize claim volumes and values by product category, business unit, or time period. The table is also a key source for interfaces to downstream financial systems for accrual and settlement posting.

Related Objects

The OZF_CLAIM_LINES_ALL table exists within a defined relational schema, with documented foreign key relationships to other critical Trade Management objects.

  • OZF_CLAIMS_ALL: This is the parent header table. The relationship is defined by the foreign key where OZF_CLAIM_LINES_ALL.CLAIM_ID references OZF_CLAIMS_ALL. A claim header will have one or more associated lines in this table.
  • OZF_CLAIM_LINES_UTIL_ALL: This table holds utilization details for claim lines. It is a child table, with OZF_CLAIM_LINES_UTIL_ALL.CLAIM_LINE_ID referencing the primary key (CLAIM_LINE_ID) of OZF_CLAIM_LINES_ALL. This allows for tracking how a claim line is applied or consumed against specific shipments or transactions.

In practice, integrations and custom reports will also frequently join this table to master data such as INV_ORG_PRODUCTS (for product details) and HR_OPERATING_UNITS (for organizational context).