Search Results ozf_claim_lines_hist_v




Overview
Explore in AI Chat

Overview

OZF_CLAIM_LINES_HIST_V is an APPS-owned view in the Oracle Trade Management (OZF) module, valid in EBS 12.1.1 and 12.2.2. It exposes the historical audit trail of claim lines processed through Trade Management settlement and payment workflows. Where OZF_CLAIM_LINES holds the current state of each claim line, the underlying history table — OZF_CLAIM_LINES_HIST — captures a snapshot row for every change event, enabling point-in-time reconstruction of a claim line's lifecycle.

The view's principal reporting value lies in its denormalization of foreign-key references into business-readable values. Rather than returning raw IDs, it resolves the payee approver, the settler, and the payment method into descriptive names, making it suitable for direct use in BI Publisher reports, OBIEE/OTBI analyses, and custom concurrent programs without additional lookup joins.

Underlying Base Objects

The view is defined over four documented base objects:

The mandatory inner join to OZF_SYS_PARAMETERS means the view returns rows only when a matching system parameter record exists for the claim's set of books; all other joins are outer, so rows are never dropped when a lookup or resource reference is null.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing who settled a claim line and when, reconciling settlement history against payables vouchers, and reproducing approval-versus-settlement timelines. Because the view is not org-striped by default, callers should filter on ORG_ID where multi-org security applies.

To identify the settler for a given claim line:

  • SELECT claim_id, claim_line_id, line_number, SETTLED_DATE, SETTLED_BY, SOURCE_NAME settler_name, PAYMENT_STATUS, VOUCHER_NUMBER FROM OZF_CLAIM_LINES_HIST_V WHERE claim_line_id = :p_line_id ORDER BY SETTLED_DATE;

To list all lines settled by a specific user resource:

  • SELECT claim_id, claim_line_id, SETTLED_DATE, claim_currency_amount, currency_code, MEANING payment_method FROM OZF_CLAIM_LINES_HIST_V WHERE SOURCE_NAME = :p_settler AND SETTLED_DATE BETWEEN :p_from AND :p_to ORDER BY SETTLED_DATE DESC;

To summarize settlement activity per resource within an operating unit:

  • SELECT SOURCE_NAME settler_name, COUNT(*) settled_lines, SUM(claim_currency_amount) total_amount FROM OZF_CLAIM_LINES_HIST_V WHERE SETTLED_DATE IS NOT NULL AND org_id = :p_org_id GROUP BY SOURCE_NAME;

These queries assume the resource name uniquely identifies the settler; where duplicate resource names exist, join SETTLED_BY back to JTF_RS_RESOURCE_EXTNS on RESOURCE_ID for precise attribution.