Search Results supp_dstr_inc_cl

Overview

APPS.DPP_XLA_CLAIM_HEADERS_V is a reporting and integration view in Oracle E-Business Suite that exposes claim and settlement transaction headers enriched with Subledger Accounting (SLA/XLA) event identifiers and derived accounting flexfield identifiers. It functions as the header-level source for the Payables and Procurement (DPP) claim settlement stream, feeding the XLA event model that generates accounting entries for supplier claims and related transactions governed by the Oracle Claims and Settlement (OZF/DPP) framework.

The view consolidates transaction header attributes, party (supplier or customer) details, and accounting distribution references into a single denormalized structure. The presence of EVENT_ID from XLA_EVENTS_GT, together with multiple package function calls in the select list, indicates that this view is intended for use within the Create Accounting or Transfer to GL processing flow, or for accounting diagnostics. It returns a literal distribution type of 'PP_CLAIM_SETTLEMENT' and a 'Y' constant, aligning it with the DPP XLA event publication pattern.

Underlying Base Objects

The view is defined over the following documented base objects, all owned by APPS:

• XLA_EVENTS_GT — a global temporary table supplying the XLA EVENT_ID context for each row.
• DPP_XLA_HEADERS — the DPP XLA header table providing PP_TRANSACTION_TYPE and BASE_TRANSACTION_HEADER_ID.
• DPP_TRANSACTION_HEADERS_ALL — the core transaction header source, supplying transaction number, org, vendor, attributes, currency, status, and effective dates.
• DPP_TRANSACTION_CLAIMS_ALL — links claim records and supplies CLAIM_TYPE, which drives party resolution.
• OZF_CLAIMS_ALL — the claim definition table providing customer, vendor, and site identifiers and the CLAIM_ID used by the clearing account lookups.
• AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL — supplier master and site data supplying vendor name and site code.
• DPP_XLA_EVENT_PUB — a PL/SQL package whose functions derive the accrual, cost adjustment, contra liability, AP clearing, and AR clearing chart-of-accounts combinations.

Key Columns

The view exposes several categories of columns of particular interest to extenders and report authors:

• EVENT_ID, TRANSACTION_HEADER_ID, BASE_TRANSACTION_HEADER_ID, TRANSACTION_NUMBER — identifiers linking the row to the XLA event and transaction chain.
• PP_ACCRUAL_CCID, PP_COST_ADJ_CCID, PP_CONTRA_LIAB_CCID, PP_AP_CLEARING_CCID, PP_AR_CLEARING_CCID — accounting flexfield identifiers resolved by DPP_XLA_EVENT_PUB, key for accounting entry validation.
• PARTY_ID, PARTY_SITE_ID, PARTY_TYPE — derived via DECODE on SUBSTR(DTC.CLAIM_TYPE,1,1); a leading 'C' resolves to customer account/site with type 'C', otherwise to vendor with type 'S'.
• VENDOR_NAME, VENDOR_SITE_CODE — presentation attributes from the supplier tables.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — descriptive flexfield context and segments from the transaction header.
• TRX_CURRENCY, TRANSACTION_STATUS, DAYS_COVERED, EFFECTIVE_START_DATE, TRANSACTION_SOURCE, CONTACT_EMAIL_ADDRESS, CONTACT_PHONE, ORG_ID — operational and organizational context.

Common Use Cases and Queries

Typical applications include auditing claim settlement accounting, verifying that the correct accrual, clearing, and contra liability accounts are derived, and building custom reports that join claim headers to their XLA events. A representative query follows:

SELECT EVENT_ID, TRANSACTION_NUMBER, PP_TRANSACTION_TYPE, VENDOR_NAME, VENDOR_SITE_CODE, PARTY_TYPE, TRX_CURRENCY, TRANSACTION_STATUS, PP_ACCRUAL_CCID, PP_AP_CLEARING_CCID FROM APPS.DPP_XLA_CLAIM_HEADERS_V WHERE ORG_ID = :p_org_id AND TRANSACTION_STATUS = 'PROCESSED';

Because the view invokes several package functions per row and joins a global temporary table, direct queries should be filtered by organization and event context for performance. It is best consumed within the XLA event processing window rather than as a high-volume operational report source.