Search Results dpp_xla_inv_headers_v

Overview

The view APPS.DPP_XLA_INV_HEADERS_V is a Subledger Accounting (SLA) integration view owned by the APPS schema and delivered as part of the Oracle Price Protection (DPP) module. It is described in the ETRM metadata as the "Dpp SLA Cost Update Header View." Its purpose is to present the transaction header information required by the SLA engine to generate accounting events for price protection cost updates. The view consolidates event identifiers, transaction header details, supplier and supplier site attributes, and derived accounting flexfield (CCID) values into a single denormalized result set, enabling the SLA program to create journal entries for cost update events without directly joining the underlying transactional and reference tables.

The view is central to the accounting flow for price protection: it exposes distribution and event context so that cost update events flow into the Subledger Accounting framework. It is populated from a global temporary table of events, the DPP header and transaction header tables, and Oracle Payables supplier reference data.

Underlying Base Objects

The view is defined over the following documented base objects:

• XLA_EVENTS_GT (SYNONYM) — the Subledger Accounting events global temporary table, supplying EVENT_ID and driving the event context for the COST_UPDATE entity.
• DPP_XLA_HEADERS (SYNONYM) — Price Protection SLA headers, supplying BASE_TRANSACTION_HEADER_ID and the processing flag/transaction type used to restrict rows.
• DPP_TRANSACTION_HEADERS_ALL (SYNONYM) — the transactional header source, providing TRANSACTION_NUMBER, vendor and site identifiers, attributes, currency, status, and other descriptive fields.
• AP_SUPPLIERS (SYNONYM) — supplier master, supplying VENDOR_NAME.
• AP_SUPPLIER_SITES_ALL (SYNONYM) — supplier site data, supplying VENDOR_SITE_CODE and ORG_ID.
• DPP_XLA_EVENT_PUB (PL/SQL PACKAGE) — provides functions that derive the accounting flexfield identifiers used as CCID columns.

Joins are driven by XEG.ENTITY_CODE = 'COST_UPDATE', with XEG.SOURCE_ID_INT_1 mapping to the transaction header ID and XEG.SOURCE_ID_INT_2 mapping to the DPP base transaction header ID. Only rows where DPP_XLA_HEADERS.PP_TRANSACTION_TYPE = 'COST_UPDATE' and PROCESSED_FLAG = 'P' are returned, ensuring only fully processed cost update events are exposed.

Key Columns

• EVENT_ID — the SLA event identifier joined from XLA_EVENTS_GT.
• DISTRIBUTION_TYPE — a literal value of 'PP_COST_UPDATE', indicating the accounting distribution type. This is the column most commonly referenced when searching for distribution_type.
• TRANSACTION_HEADER_ID and BASE_TRANSACTION_HEADER_ID — identifiers for the current and originating price protection transaction headers.
• TRANSACTION_NUMBER — the human-readable transaction reference.
• VENDOR_NAME and VENDOR_SITE_CODE — supplier and site descriptive values.
• PP_ACCRUAL_CCID, PP_COST_ADJ_CCID, and PP_CONTRA_LIAB_CCID — accounting flexfield code combinations returned by the DPP_XLA_EVENT_PUB functions, used for accrual, cost adjustment, and contra-liability postings.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 — descriptive flexfield context and segment values.
• TRX_CURRENCY, TRANSACTION_STATUS, EFFECTIVE_START_DATE, DAYS_COVERED, CONTACT_EMAIL_ADDRESS, CONTACT_PHONE, and ORG_ID — supporting transaction and organization attributes.

Common Use Cases and Queries

Typical use cases include reviewing SLA cost update events for price protection, validating the CCIDs generated for a transaction, and diagnosing why accounting entries were or were not created. A common query filters on the distribution type literal:

• SELECT event_id, transaction_header_id, transaction_number, vendor_name, pp_accrual_ccid, pp_cost_adj_ccid FROM apps.dpp_xla_inv_headers_v WHERE distribution_type = 'PP_COST_UPDATE';
• Retrieving derived accounting combinations for a specific transaction header to reconcile accrual, cost adjustment, and contra-liability postings.
• Auditing processed events by joining against DPP_TRANSACTION_HEADERS_ALL or the SLA event tables on EVENT_ID.

Because DISTRIBUTION_TYPE is a hard-coded literal, all rows returned by this view belong to the PP_COST_UPDATE distribution, which simplifies filtering and downstream SLA event processing.