Search Results pa_transfer_ap_invoices_view




Overview
Explore in AI Chat

Overview

PA_TRANSFER_AP_INVOICES_VIEW is a Projects (PA) module database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to present project-related invoice distributions originating in Oracle Payables (AP). The view consolidates invoice distribution attributes, purchase order accrual context, and prepayment exchange-rate derivation into a single queryable structure. It is primarily used by the Payables-to-Projects transfer and integration processes, which identify AP invoice distributions that are chargeable to projects and convey them into Project Costing for expenditure processing and subsequently into Project Billing.

Because the view is defined over AP invoice distribution data rather than directly over a table, it serves as a stable reporting and integration interface. The AMOUNT_VARIANCE column, which the user searched for, is inherited directly from AP_INVOICE_DISTRIBUTIONS and represents the variance between an invoice distribution amount and its matched purchase order or receipt reference amount, making it relevant to match variance analysis and reconciliation reporting.

Underlying Base Objects

The documented base objects referenced by the view are AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_SELF_ASSESSED_TAX_DIST, AP_SYSTEM_PARAMETERS, AP_UTILITIES_PKG, MTL_SYSTEM_ITEMS, PA_NL_INSTALLED, PO_DISTRIBUTIONS, and PO_LINES_ALL. All the AP, MTL, and PO objects are accessed through synonyms, while AP_UTILITIES_PKG is a PL/SQL package.

Key Columns

Common Use Cases and Queries

The view is typically queried to identify project-related AP invoice distributions eligible for transfer to Projects, or to analyze match variances. A representative query filters on a specific invoice and examines the variance columns:

  • SELECT invoice_id, invoice_distribution_id, amount, amount_variance, base_amount_variance FROM apps.pa_transfer_ap_invoices_view WHERE invoice_id = :invoice_id;
  • SELECT invoice_distribution_id, period_name, posted_flag, amount FROM apps.pa_transfer_ap_invoices_view WHERE set_of_books_id = :sob AND period_name = :period;

Because AMOUNT_VARIANCE is exposed directly, users can aggregate variance by period, supplier, or PO distribution to reconcile invoice-to-PO matching discrepancies prior to project cost transfer.