Search Results pa_pwp_ap_inv_dtl




Overview
Explore in AI Chat

Overview

PA_PWP_AP_INV_DTL is a temporary (staging) table owned by the PA (Projects) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores processed supplier invoice data at the invoice distribution level, acting as the granular counterpart to its parent header table PA_PWP_AP_INV_HDR. The table is used during the processing cycle of supplier invoices that must be matched to project and task information, most notably in the context of Project Procurement and Payables integration flows that feed project cost collection and expenditure item creation.

The documented physical schema for release 12.2.2 lists 36 columns under the PA schema. The foreign key metadata shows that PA_PWP_AP_HDR_ID on this table references PA_PWP_AP_INV_HDR, establishing a header-to-detail parent-child relationship. Based on the heuristic Data Vault classification mined from the FK structure, this object can be modeled as a link, since it connects the invoice header context to project, task, and purchase order business entities rather than functioning as an independent hub or a descriptive satellite.

Key Information Stored

Each row represents one processed supplier invoice distribution across three distinct currency perspectives (project functional, project, and accounting), which is the defining characteristic of the table's design.

No surrogate primary key or unique index is documented in the supplied metadata; the header foreign key PA_PWP_AP_HDR_ID, combined with INVOICE_ID, functions as the practical business-key candidate.

Common Use Cases and Queries

The table is most frequently queried during reconciliation of Payables invoices against project-reported costs, particularly to verify that paid, unpaid, retained, and discount amounts have been distributed proportionally across currencies before expenditure items are generated.

A representative reconciliation query joins the detail to its header:

  • SELECT d.INVOICE_ID, d.PROJECT_ID, d.TASK_ID, d.PROJFUNC_INVOICE_AMOUNT, d.PROJ_INVOICE_AMOUNT, d.ACCT_INVOICE_AMOUNT FROM PA.PA_PWP_AP_INV_DTL d, PA.PA_PWP_AP_INV_HDR h WHERE d.PA_PWP_AP_HDR_ID = h.PA_PWP_AP_HDR_ID AND d.INVOICE_ID = :invoice_id;

Because the table is temporary, reporting typically occurs within the processing window or against archived extracts. Common reporting scenarios include outstanding unpaid analysis by project and task, retained amount tracking, recoverable tax breakdowns, and validating the paid percentage fields used for proportional distribution logic.

Related Objects

  • PA_PWP_AP_INV_HDR — parent header table; joined via PA_PWP_AP_INV_DTL.PA_PWP_AP_HDR_ID = PA_PWP_AP_INV_HDR.PA_PWP_AP_HDR_ID.
  • AP_INVOICES_ALL — source supplier invoice header, referenced through INVOICE_ID.
  • AP_INVOICE_DISTRIBUTIONS_ALL — source invoice distribution detail.
  • PA_PROJECTS_ALL — project master, referenced through PROJECT_ID.
  • PA_TASKS — task master, referenced through TASK_ID.
  • PO_HEADERS_ALL — purchase order header, referenced through PO_HEADER_ID.
  • PA_EXPENDITURE_ITEMS_ALL — downstream project cost records generated from processed distributions.