Search Results ozf_claim_lines_hist




Overview
Explore in AI Chat

Overview

The APPS.OZF_CLAIM_LINES_HIST_V view is a historical reporting construct within the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / ETRM) module. It exposes claim line history records — the denormalized, point-in-time snapshots of individual claim lines that are created whenever a claim is approved, updated, settled, or otherwise modified through the claim lifecycle. Unlike the transactional OZF_CLAIM_LINES table, which holds only the current state of a claim line, the history view preserves successive versions so that auditors, settlement analysts, and channel program administrators can reconstruct the financial and approval trail of a claim over time.

The view is defined in the APPS schema and, as documented in the ETRM 12.2.2 metadata, joins the claim line history base table to the system parameters table, the payment-method lookup view, and two instances of the resource extension table. This makes it a convenient single source for reporting that requires the claim line history plus the descriptive meaning of its payment method and the names of the resources who approved and settled the line. It is commonly consumed by concurrent programs, Oracle Discoverer/BIP reports, and custom integrations that reconcile trade claims against payables and receivables.

Underlying Base Objects

The documented referenced base objects are:

The joins are largely outer joins, ensuring history rows are returned even where the payment method lookup or a related resource name is unavailable. The dependency on OZF_SYS_PARAMETERS is significant: it ties every returned row to a configured set of books, which also explains why the user search term "ozf_sys_parameters" surfaces this object.

Key Columns

The view projects the full column list of OZF_CLAIM_LINES_HIST, including:

Common Use Cases and Queries

Typical scenarios include claim audit trails, settlement reconciliations, and analysis of approval turnaround. A representative query returning the latest history version per claim line follows:

SELECT claim_line_id, line_number, amount, acctd_amount, payment_status, meaning, approved_date, settled_date
FROM apps.ozf_claim_lines_hist_v
WHERE org_id = :p_org_id
  AND approved_flag = 'Y'
  AND settlement_date BETWEEN :p_from AND :p_to;

A second common pattern joins back to the current claim line to compare the historical snapshot against the live row, or groups by OFFER_TYPE and ITEM_TYPE to report accrual versus settlement by program. Because the view enforces the OZF_SYS_PARAMETERS set-of-books relationship, queries are implicitly scoped to configured accounting books, which simplifies multi-org reporting but requires that system parameters be correctly maintained for the operating unit being queried.