Search Results ap_ppa_invoice_dists_gt




Overview
Explore in AI Chat

Overview

AP_PPA_INVOICE_DISTS_GT is a Payables module table owned by the AP schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The suffix _GT identifies it as a global temporary table. In the Oracle EBS architecture, global temporary tables are used as transient staging structures whose data is visible only within a session or transaction. In the context of Payables, AP_PPA_INVOICE_DISTS_GT supports the Public Sector Payables (PPA) processing path, which handles invoice distributions subject to special accounting treatments such as award tracking, project-related expenditure recognition, and withholding tax processing.

The physical schema documented in ETRM 12.1.1 contains 108 columns, reflecting the breadth of attributes required to capture invoice distribution detail while also carrying ancillary data for assets, projects, encumbrances, tax, and payables withholding. Although the object is not formally constrained as a parent or child within a warehouse star schema, the heuristic Data Vault classification derived from its foreign key structure is standalone, suggesting it is best modeled as an independent staging or source object rather than a standard hub, link, or satellite.

Key Information Stored

The most consequential columns in this table describe the identity, accounting, and classification of each invoice distribution line:

The surrogate key is INVOICE_DISTRIBUTION_ID. Business-key candidates for uniqueness are formed from INVOICE_ID, INVOICE_LINE_NUMBER, and DISTRIBUTION_LINE_NUMBER.

Common Use Cases and Queries

This staging table is typically populated during PPA invoice processing and consumed to produce permanent invoice distribution records. Common scenarios include:

  • Reviewing unposted accrual or cash lines before final posting:
SELECT invoice_id, invoice_line_number, distribution_line_number,
       amount, accounting_date, period_name, posted_flag
FROM   ap.ap_ppa_invoice_dists_gt
WHERE  posted_flag = 'N';
  • Award-linked reporting for Public Sector clients:
SELECT g.award_id, a.award_number, SUM(g.amount) award_total
FROM   ap.ap_ppa_invoice_dists_gt g,
       igf.igf_aw_award_all a
WHERE  g.award_id = a.award_id
GROUP  BY g.award_id, a.award_number;
  • Reconciling project expenditure attributes before Project Accounting import.
  • Validating distribution class and lookup codes against FND_LOOKUPS.
  • Auditing withholding tax distributions using WITHHOLDING_TAX_CODE_ID and AWT_GROUP_ID.

Related Objects

The following objects are most significant when working with this table:

  • IGF_AW_AWARD_ALL — joined on AWARD_ID; the sole documented foreign key target.
  • AP_INVOICE_DISTRIBUTIONS_ALL — the permanent distribution table populated from staged rows via INVOICE_DISTRIBUTION_ID.
  • AP_INVOICES_ALL — parent invoice header, joined on INVOICE_ID.
  • AP_INVOICE_LINES_ALL — invoice line detail, joined on INVOICE_ID and INVOICE_LINE_NUMBER.
  • AP_PAYMENT_SCHEDULES_ALL — payment schedules generated from distributions sharing INVOICE_ID.
  • GL_CODE_COMBINATIONS — accounting flexfield validation, joined on DIST_CODE_COMBINATION_ID.
  • PA_PROJECTS_ALL and PA_TASKS — project and task validation on PROJECT_ID and TASK_ID.
  • FA_ASSET_HEADERS / FA_ADDITIONS_B — asset creation targets referenced through the asset tracking flags.