Search Results ap_ppa_invoice_lines_gt




Overview
Explore in AI Chat

Overview

AP_PPA_INVOICE_LINES_GT is a Payables (AP) schema table that functions as a global temporary (GT) staging structure for invoice line data during invoice import and validation processing. It is populated by the Payables Invoice Import and related partner/procurement activity programs, which load external invoice line records into this staging area before Oracle validates and commits them to the permanent AP_INVOICE_LINES_ALL structure. The table carries 160 documented columns in ETRM 12.2.2, reflecting the broad range of attributes that must be captured for invoice lines spanning standard, purchase order matched, project-related, and tax-bearing transactions.

From a Data Vault modeling perspective, the ETRM heuristic classifies this object as standalone. This classification reflects its nature as a transient staging container rather than a persisted entity: it holds no incoming foreign-key dependencies and does not serve as a durable hub, link, or satellite for downstream history. Analysts should treat it as a processing structure whose contents are session-scoped and may be cleared after import completes.

Key Information Stored

The table's most significant columns define the identity, origin, accounting, and matching context of each staged invoice line:

The table does not expose a documented surrogate primary key in the ETRM metadata; INVOICE_ID plus LINE_NUMBER constitute the practical business-key candidate.

Common Use Cases and Queries

The dominant use case is diagnosing invoice import failures and validating staged data before commit. A typical query lists staged lines for a given invoice:

  • SELECT invoice_id, line_number, line_type_lookup_code, amount, po_header_id, po_line_id FROM ap_ppa_invoice_lines_gt WHERE invoice_id = :p_invoice_id ORDER BY line_number;
  • Reconciliation against final lines: join AP_INVOICE_LINES_ALL on invoice_id and line_number to detect lines that failed validation.
  • PO match analysis: group by po_header_id to confirm expected receipt and distribution references are populated.
  • Tax audit: filter SUMMARY_TAX_LINE_ID IS NOT NULL to verify tax lines reconcile to ZX_LINES_SUMMARY.
  • Data quality reporting: count lines where LINE_TYPE_LOOKUP_CODE or AMOUNT is null before import submission.

Because the table is session-scoped, queries must run within the importing session or immediately after load.

Related Objects

  • AP_INVOICE_LINES_ALL — Permanent target that receives validated rows from this staging table.
  • PO_RELEASES_ALL — Referenced via PO_RELEASE_ID for release-level matching.
  • IGF_AW_AWARD_ALL — Referenced via AWARD_ID for grants-funded lines.
  • ZX_LINES_SUMMARY — Referenced via SUMMARY_TAX_LINE_ID for tax summary linkage.
  • FTE_INVOICE_LINES — Referenced via INVOICE_LINE_ID, providing the associated invoice line record.
  • IGI_DOS_TRX_SOURCES — Referenced via SOURCE_TRX_ID, linking staged lines to their originating transaction source.