Results for “performance_complete_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OZF_CLAIM_LINES_INT_ALL is a Trade Management (OZF) interface table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores claim line records staged for import into the application. Claim lines represent the individual detail rows belonging to a vendor or customer claim — the amounts, items, activities, and payment attributes that make up the claim. The _INT_ALL suffix indicates that the table is a multi-org interface (staging) table, so records reside here prior to validation and transfer into the base claim line tables by the Claim Import concurrent program.

Each row carries a REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID, allowing the import process to identify and reprocess rows by submission. The VALID_FLAG column records validation status during import.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning: it holds descriptive and qualifying attributes about claim lines and depends on parent entities via its foreign keys, rather than acting as a pure hub or a many-to-many link. This is a heuristic suggestion, not a formal Oracle classification.

Key Information Stored

The table contains 88 documented columns. The most significant are:

• INTERFACE_CLAIM_LINE_ID — surrogate primary key (OZF_CLAIM_LINES_INT_ALL_PK) and the unique business-key candidate in OZF_CLAIM_LINES_INT_ALL_U1.
• INTERFACE_CLAIM_ID — foreign key to OZF_CLAIMS_INT_ALL; ties the line to its parent interface claim header.
• LINE_NUMBER — sequence of the line within the claim.
• AMOUNT and ACCTD_AMOUNT — entered and accounted claim line amounts.
• CURRENCY_CODE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE, SET_OF_BOOKS_ID — currency conversion context.
• UTILIZATION_ID — foreign key to OZF_FUNDS_UTILIZED_ALL_B, linking the line to the accrual or fund utilization it draws against.
• PLAN_ID, OFFER_ID, OFFER_TYPE — the trade plan and offer the claim relates to.
• ITEM_ID, QUANTITY, RATE, ITEM_TYPE — product and pricing detail.
• SOURCE_OBJECT_ID, SOURCE_OBJECT_LINE_ID, SOURCE_OBJECT_CLASS — reference to the originating document line.
• APPROVED_FLAG, PAYMENT_STATUS, VOUCHER_NUMBER, PAYMENT_REFERENCE_ID — settlement and approval state.
• VALID_FLAG — import validation outcome.
• ORG_ID and SECURITY_GROUP_ID (FK to FND_SECURITY_GROUPS) — multi-org and security access scoping.
• ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield segments.

Common Use Cases and Queries

Typical uses include monitoring import status, reconciling interface lines to base claims, and diagnosing failed loads.

-- Failed or unvalidated lines for a concurrent request
SELECT h.INTERFACE_CLAIM_ID, l.INTERFACE_CLAIM_LINE_ID,
       l.LINE_NUMBER, l.AMOUNT, l.CURRENCY_CODE, l.VALID_FLAG
FROM   OZF_CLAIM_LINES_INT_ALL l
       JOIN OZF_CLAIMS_INT_ALL h
         ON h.INTERFACE_CLAIM_ID = l.INTERFACE_CLAIM_ID
WHERE  l.REQUEST_ID = :request_id
AND    NVL(l.VALID_FLAG,'N') = 'N';

-- Lines grouped by trade plan and offer
SELECT PLAN_ID, OFFER_ID, COUNT(*) line_count, SUM(AMOUNT) total_amount
FROM   OZF_CLAIM_LINES_INT_ALL
WHERE  ORG_ID = :org_id
GROUP  BY PLAN_ID, OFFER_ID;

Because the table stages import data, most operational queries filter on REQUEST_ID, ORG_ID, or VALID_FLAG, and reporting is often performed after the lines have transferred to the base claim tables.

Related Objects

• OZF_CLAIMS_INT_ALL — parent interface claim header; joined on INTERFACE_CLAIM_ID.
• OZF_FUNDS_UTILIZED_ALL_B — fund utilization referenced by UTILIZATION_ID.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID.
• Base claim line tables in the OZF schema — the post-import destination of validated records.
• Claim Import concurrent program (Trade Management) — consumes these rows through its request identifier and program columns.
• Trade Management plan and offer entities referenced by PLAN_ID and OFFER_ID.
• Payables voucher and payment objects referenced by VOUCHER_ID and PAYMENT_REFERENCE_ID.